Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following data
Product | Team | Sales |
---|---|---|
Apple | Jason | 1 |
Lemon | Jason | 0 |
Lemon | Peter | 2 |
Lemon | Mark | 3 |
I created a Pie chart and with Dimension = Team, Measure = Sum(Sales)
and an Filter Pane with Dimension = Product
When I select Lemon, the chart show Peter (40%) and Mark (60%) but also have a note "The data set contains negative or zero values that cannot be shown in this chart." because the value of Jason is 0.
How can I suppress the "contains zero" note? I try use some set express in Dimension but no luck. Thanks
In the Properties pane for the Pie Chart, under the "Team" dimension - set the Limitation = Exact Value and use >0
Then untick "Show others"
Hi ,
You cannot suppress that statement.
Instead you have to modify your data select statement as >0
May be use this as your expression:
If(Sum(Sales) > 0, Sum(Sales))
Sunny's expression should solve it for you
In the Properties pane for the Pie Chart, under the "Team" dimension - set the Limitation = Exact Value and use >0
Then untick "Show others"
This works. Thanks
Thanks for Help All.
Really Appreciated