I have a scenario where in I have to plot a pie chart with 2 different values. One being my original expression (say for example it is 20%) and rest other categories are not having any values (0). Hence I have to show the pie chart including this 80% as one angle for all the zero values and 20% as other angle in the same pie. Is there a way I could negate my original expression and achieve the second expression? I could get this easily with a bar/mekko chart but not with the pie !
Thanks for sharing App, Now coming to your query. Is that possible to show which you expect from Pie chart. Please make sketch on paper and then share with us. So, Might very helpful to explain you
Please find the attached app. For the purpose you are looking for , Bar chart is appropirate.
However, i tried concatenating the field and created a pie. please take a look