Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

How to create Cumulative trend for aggregated measures in SAS VA

Reply
New User
Posts: 1

How to create Cumulative trend for aggregated measures in SAS VA

I am trying to create a cummulative trend over a period of time for Penetration %, which is a aggregated measure. But SAs Va only allows me to use a measure as a value to create a cumulative variable. Is there a way to create this in SAS VAva.PNG

Contributor
Posts: 42

Re: How to create Cumulative trend for aggregated measures in SAS VA

Posted in reply to kvrkrishreddy

You can't - Can't you just use your penetration measure? Penetration% must just be a calculated items: x/y * 100? 

Frequent Contributor
Posts: 131

Re: How to create Cumulative trend for aggregated measures in SAS VA

[ Edited ]

You could probably use the CumulativePeriod function to calculate the numerators and denominators (X & Y) seperately for a specific period then divide them in a third aggregated measure which would give you the % for the period.

 

Ask a Question
Discussion stats
  • 2 replies
  • 325 views
  • 0 likes
  • 3 in conversation