Do you know what release the 100% stacked bar chart will be in?
Also I was wondering whether having this aggregation would also provide a 100% within a category group for a cross tab so that rather than a percent of total measure all adding up to 100% in a crosstab it will be 100% within each column for instance. (I think I had raised a tech support feature request for this in the past.)
Stacked bar charts can be done in VA, even with 6.2. (Without custom chart types).
What you need to do is convert your variables in to aggregated measures in VA (as percentages).
So if I have measures called A, B, C and "total" measure, create "New Aggregated Measure" for A/B/C.
This creates a new "aggregated measure" which I called %A. If I do B and C, I can drop them onto a bar chart with "stacked" chosen to get a graph like this:
We recently upgraded to VA 6.4, but the above screenshot was actually taken from 6.2. The category at the bottom that I call module can be anything that the data supports.
I really like it! It's much simpler than my approach.
Just expanding on your solution, I'd like to show how to derive A,B,C, etc. as mentioned in your example (in case they don't exist) for any existing measure, which makes this solution even more flexible.
I have 3 columns of interest:
I want to show % Revenue for Product Lines per Facility Region.
To calculate Revenue for Product Line A:
Repeat that for all Product Lines, and then calculate their respective percentages (aggregated measures) as indicated before:
And that's the final chart:
The same approach can be used to combine multiple Product Lines (and call them Others), if we are mostly interested on A and B only:
Thanks for both of these notes, it is useful to see this solution I can see how it will work when you have a distinct set of values (product lines) in the above example, however if you have a dynamic set of values you need to create an aggregated measure for each one, which will require constant maintenance to completely add up to 100% for each if you are interested in the detail.
The limitation to this is you need to repeat this process for each individual measure you choose which can become quite time consuming and prone to error!
The early bird rate has been extended! Register by March 18 for just $695 - $100 off the standard rate.
Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
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.