Pie chart remove 0 values and only show chart on selection

Question

Is there a way to display pie chart data to only show the selection. E.g below are a list of bookings for a doctor. I do not want to see the zero pie slices.&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

On the filter pane, for your values field, select show where value &gt; 0&nbsp;&nbsp;

ms999 · Answer

tried that and '1' but still shows all the 0 pie slices&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

Could you check that you don't have "show items with no data" selected?&nbsp;&nbsp;

ms999 · Answer

Do not have that option on the values field&nbsp;and not selected on legend&nbsp;&nbsp;&nbsp;

Forum Discussion

Pie chart remove 0 values and only show chart on selection

4 Replies

Related content

remove duplicate value within a row

Display Selected and not selected values

Selectively remove duplicate rows?

Remove Duplicate Values in Column

Removing rows with all null values