topic Re: Remove a category (slice) from a Pie Chart in Data Engineering

Remove a category (slice) from a Pie Chart

eques_99 — Thu, 17 Nov 2022 19:11:15 GMT

I added a grand total row to a "Count" in SQL, which I needed for some counter visualisations. I used the "ROLL UP" command to get the grand total.

However, I have a pie chart which references the same count, and so the grand total row has been added as a slice on the pie chart (obviously 50% of the pie)

There is no obvious way in the "Edit Visualisation" section to filter out rows.

I can click on the relevant legend, which filters the slice out of the pie chart. However the legend itself is still showing on the visualisation, which I don't want. (see underneath red arrow on attached image)

Any ideas how I would get rid of it from this visualization?

I have tried adding filters at Query level, but that also removed the grand total from the counters!

Thanks

Re: Remove a category (slice) from a Pie Chart

eques_99 — Fri, 18 Nov 2022 09:32:14 GMT

hi, as per the picture above, the slice disappears but the name ("null" in this case) remains on the legend.

Re: Remove a category (slice) from a Pie Chart

Debayan — Fri, 18 Nov 2022 07:10:50 GMT

Hi @harry ryder , Could you please confirm when you are try to hide it temporarily what is happening?

https://docs.databricks.com/sql/user/visualizations/charts.html#temporarily-hide-or-show-only-a-series