About jrippberger

jrippberger · ‎05-28-2020

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

jrippberger · ‎05-27-2020

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

jrippberger · ‎05-06-2020

I managed to show the Calculation as an extra filter which is mandatory and which sets a parameter called "Display" and used this Display parameter in the text field. But now I have this extra filter visible in my dashboard.

jrippberger · ‎05-06-2020

Hey there, I am new to SAS VA and I have a questions: I have set two dropdown filters: Continent and Country. Each of these sets a parameter (ContinentParam and CountryParam). I now want a text field to show Continent, if ContinentParam is set and CountryParam isn't, Country, if CountryParam is set "All" if none is set. I have build a calculation which looks like above and which works. This calculation however results in a Category which can't be used in Text fields. Is there a way to show the result in a text field?

Online Status	Offline
Date Last Visited	‎05-29-2020 09:41 AM

Re: Cumulative Average past to date

Cumulative Average past to date

Re: Using Parameter Calculation in Text

Using Parameter Calculation in Text

Re: Using Parameter Calculation in Text

Re: Cumulative Average past to date

Cumulative Average past to date

Re: Using Parameter Calculation in Text

Using Parameter Calculation in Text