In SAS Visual Analytics, how do you display the percent of a whole and still allow it to be drillable.
For example I have a
Hierarchy: Peer group >> institution
Category: Rank
Measure: Employees
I need to be able to display the % of employees at any given point of the hierarchy and by rank.
Under properties the option normalize groups to 100% handles it. Although the scaling is off.
Hi David,
1) Create an Aggregated Measure i.e., Employees Bygroup / Employees Forall. Then Change the column properties to Percent.
Or
2) If you are using Cross Table then you can create Sub Total.
Thanks,
Teja
Teja,
I like the concept. When I select two institutions at the same time my percents are split between the institutions rather than percent per institution.
Under properties the option normalize groups to 100% handles it. Although the scaling is off.
Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.
Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.
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.