Pie chart : How to deal with Nulls

[shwetapsarda]

Hi,

I want to make a pie chart by

dimension as State and measure as exposure.

Also I want to show top 5 states on chart and remaining as others. I did this by

My Graph shows

Problem: Here yellow portion which shows 4% are having State value as 'Null'. I want to show these Nulls to include into  the 'Others' and want only 5 states with valid value to be displayed. How to do this?

Thanks,

Shweta

[OmarBenSalem]

You cannot show null value with others; but I'd propose that u eliminate it from the pie chart as follow:

if(IsNull(YourDim)<>-1, sum(YourMeasure))

and in the title of the chart, mention that the % of your Null values is 4.4%

sthing like:

='NB: Null values represents : '&

(num(sum({<YourDim={"=IsNull(YourDim)=-1"}>}YourMeasure)/ sum(total YourMeasure),'# ##0,00%'))

.