Hi all,
I have the below table which columns are automatically updated every month with new data.
I created a chart in my App and set all columns as visible, then in the chart I have added those months columns in the "Chart columns" details - which columns to include.
I would like to show in the chart ONLY the months with data, which means data > 0. I tried to use the show_if option in the columns "Data" menu but adding for instance this "[May 2022] > 0.00" but it does not work, it always shows "May 2022" even when value is 0.00
Any ideas?
Thanks in advance.
Solved! Go to Solution.
Create a slice on the table. Use the slice row filter condition to omit rows with zero values. Base your chart on the slice rather than the table.
User | Count |
---|---|
15 | |
11 | |
7 | |
3 | |
2 |