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

cumulative Chart in SAS VA

Reply
Contributor
Posts: 25

cumulative Chart in SAS VA

(Filter) Period : 01 May  - 05 May

values for 2016 > 10 5 0 5 7 ie cumulative 10 15 15 20 27

values for 2015 > 11 6 5 0 8 ie cumulative 11 17 22 0 30

 

 

How can I chart above mentioned cumulative values in a line chart

 

SAS Super FREQ
Posts: 706

Re: cumulative Chart in SAS VA

Hi

 

add a new data item like below and use this in your line chart. Using the RightMouseButton on any item is always a good idea to explore what is possibe.

 

Capture.PNG

 

The graph will look then like

Capture.PNG

Bruno

Contributor
Posts: 25

Re: cumulative Chart in SAS VA

[ Edited ]

Thanks Bruno,
I've tried that, but when the period exceeds one month ie at 01 values are cumulating for different months ie 01 may + 01 june which is shouldn't be...
I guess there no sas date format which gives only date and month 01May, 01Jun..( we can sub-string but then it will loose its sorting)
I have also tried to crate a calculated item DayofYear(0-365 items) but again it cumulate different years there..(which works for non aggregated measure)

 

Any alternative.

Thanks again for your help.

Contributor
Posts: 25

Re: cumulative Chart in SAS VA

[ Edited ]

for what is worth I am attaching both linear trend and cummulative trend charts which i'm able to generate.

But I'm not able to generate combination of these two.

Untitled.png

ie I want overlapping cumulative value for dayofyears

 

 + period to date gives me cumulation for all values till that date but I want start date to be specific.

 


Untitled2.png
Ask a Question
Discussion stats
  • 3 replies
  • 626 views
  • 0 likes
  • 2 in conversation