10 Replies Latest reply: Feb 1, 2018 1:44 PM by omar bensalem RSS

    Pie chart : How to deal with Nulls

    Shweta Sarda

      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