Semi additive measures in VA

FrankE — Thu, 24 Feb 2022 20:44:49 GMT

I have a dataset that includes several periods of data with a period end balance on each record. My VA report has a period slider at the top that I can use to select the date range for the report. I'm looking to display the current balance as of the upper bound of the date slider. I believe this would be considered a semi-additive measure? Can someone point me in the direction as how to handle this?

Example:

CustomerID Period Balance

1234 Jan2001 $300

1234 Feb2001 $100

1234 Mar2001 $300

Just using the default aggregation, the field would show the sum of the rows included by the slider. What I want is the balance as of the end of the slider.

topic Semi additive measures in VA in SAS Visual Analytics

Semi additive measures in VA