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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.