topic Re: Cumulative Average past to date in SAS Visual Analytics

Cumulative Average past to date

jrippberger — Wed, 27 May 2020 15:09:43 GMT

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

Re: Cumulative Average past to date

PetriRoine — Thu, 28 May 2020 05:54:49 GMT

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.

In the Data pane, right-click the Measure data item and selected New calculation.
Give a sensible Name and specify the Type: Cumulative Total.
Click OK.

I hope this helps.

Best regards,

Petri

Re: Cumulative Average past to date

jrippberger — Thu, 28 May 2020 15:03:09 GMT

Hi Petri,

thanks for your answer. That would indeed help very much since I would only have to divide this by the cumulative total of the count of events.
But I don't seem to have that option:
My VA does only display the following options for type (i translated them from german to english):
Difference to the same interval in the past
Difference to a interval in the past
Difference to the same interval in the past - percent
Difference to a interval in the past - percent
Percent of Sum - Counts
cumulative periodic value
growth comparison
cumulative year value
cumulative year growth.

So somehow VA will only let me cumulate my values by specific time intervals not "total".
Although it seems I only have access to the SAS release 7.5 which is unfortunate.

Best regards,
jripp

Re: Cumulative Average past to date

PetriRoine — Fri, 29 May 2020 11:15:27 GMT

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