Null (empty cells) as a Category in Graph Legend

Null shows as a category on a legend

Is there a way to hide/remove null category from the legend (see image)? Why does it even show as a category? It is just an empty cell.

Technical details:

  • Redash Version:10
  • Browser/OS:Chrome
  • How did you install Redash: AWS self-hosting

Can you share a sample of the data that draws this? I’m not able to reproduce it locally.

Typically the solution here is to modify your query so it doesn’t return data that you don’t want to visualise.

Yes, I can make a query to exclude empty cells, but still null should not show up anyway.

The data looks something like that

A | B | C
25|2 | Manatee
28 |5 | Dolphin

The middle row does not have a data point on the graph, but the “null” category still shows up in the legend.

but still null should not show up anyway.

Actually it should. From what you’ve described this isn’t a flaw with Redash. It’s doing exactly what you told it to do. You’ve asked it to group by column C. One of the values in column C is blank/null. So that value will be displayed.

Redash visualisations do not filter data. So the correct place to change this is in your SQL query.

ok, I guess, we can do a query.