topic Re: How do I not show some dimension value in a pie chart? in App Development

How do I not show some dimension value in a pie chart?

Noor51 — Wed, 10 Apr 2024 18:19:11 GMT

Hello,

I have a pie chart that I create, but I don't want to show a one value of the dimension. I don't want to remove the data, I just want to change the order. The chart shows the top 10 companies in the market.

I heard that script chart could maybe do it, but I don't know how to though. Down below is the chart. I want to ignore Hikma for the top 10.

Re: How do I not show some dimension value in a pie chart?

rwunderlich — Thu, 11 Apr 2024 19:22:06 GMT

Add a set expression to remove Hikma like:

{<Company-={'Hikma'}>}

-Rob

Re: How do I not show some dimension value in a pie chart?

Noor51 — Thu, 11 Apr 2024 21:18:14 GMT

Thanks for the solution. Is there a way so that it hide it because the % changes when I use it and I don't want the % to change? Or is there a way to put Hikma in the others section?

Thanks

Gurnoor

Re: How do I not show some dimension value in a pie chart?

rwunderlich — Thu, 11 Apr 2024 23:49:09 GMT

You could put Hikam in the Others by using a calculated Dimension like:

=Aggr(if(Rank(Sum({<Customer-={'Hikma'}>}Sales)) <=10, Customer, 'Others'), Customer)

or if Sum(Sales) is already a Master Measure named Sales:

=Aggr(if(Rank({<Customer-={'Hikma'}>}Sales) <=10, Customer, 'Others'), Customer)

-Rob