I am looking for help on how to go about building a Cumulative % Line chart in SAS VA 7.4. The catch is that the Cumulative % is not based on dates/time, but based on ranges of how long it took to answer a call. here is the view that I have based on the % at each range, but the client wants to see the result as a cumulative line chart.
What I did currently was create a Aggregated measure that is % of total. And then plotted on chart with the category for how long it took to answer the call.
Any thoughts / suggestions would be greatly appreciated.
Greg
Hello @gkokanour ,
I'm under impression that cumulative calculations for non-datetime categories is not possible in VA 7.4. The capability to build cumulative totals across any category, not just time, was introduced in SAS VA 8.2.
I have one trick in my sleeve which might work. Waterfall diagram is cumulative by nature and naturally works across any category type. Maybe you could you utilize that?
I hope this helps a little.
Best regards,
Petri Roine
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.