I've got a dataset for a VA report I made which contains utilization (in percentages) of limits per counterparty per day. For a quick overview I made a bar chart that shows the latest day in the dataset and the utilization for each counterparty. When I use rank to show the top 7 counterparties out of total 10 the second largest gets pooled into the All other group. If I uncheck the All other box this second largest counterparty per utilization on the latest day does not show up.
This counterparty has fewer datapoints then the others, 46 for most others vs 6 for this one that doesn't appear. I manually entered in a 0 utilization for this counterparty for the days that the counterparty has no values, thinking that this might be the problem but to no avail. It still doesn't show up in the top 7 group and gets pooled into the all other.
Anyone here had something similar happen to them and might offer a solution?
UPDATE: After getting a solution to my sorting a bar chart by measure by making a custom bar chart this is no longer an issue if I use the custom graph. But it still an issue with the out of the box bar chart.
Anyone from SAS here that might know what might cause this error?
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.