Hi,
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?
We're using version 7.4.