Hi all,
is it possible to create a cumulative average for all past times?
I have only found the option to do this with relative dates. But if I have a dataset of multiple years I cannot put all the months in manually.
At each step it must include all previous values but not future ones. I can't aggregate on cell level because I cannot name a unique identifier.
Thank you very much!
The data set might look like this:
Date Measure Wanted
01/01/2016 0.15 0.15
01/02/2016 0.20 0.175 ((0.15+0.20)/2)
.
.
.
01/03/2017 0.05 Sum(Measure(where date is before current date))/n
Hello @jrippberger ,
Does this look something you are after? (Done in VA 8.5)
My source data had two columns: Date, Measure
I created a new measure Cumulative Sum by creating a Derived Item.
I hope this helps.
Best regards,
Petri
Visual Analytics 8.2 introduced new one-click calculations including (the one I used) cumulative total (which can work across any dimension), moving average, and data suppression (which obscures an aggregated measure value if detail measure values could be easily inferred when too few rows contribute to the aggregated measure value). Although version VA 7.5 inherited great things from VA on Viya, apparently these one-click calculations were not on the list.
Best regards,
Petri
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.