3

I'm making some dashboards in superset apache, but I have the problem that it makes me null when it doesn't find values to add and this is annoying for the view, for the client. I can't find an option that suppresses the null values or in any case that puts zero.

thanks

enter image description here

TylerH
  • 20,799
  • 66
  • 75
  • 101
Danieledu
  • 391
  • 1
  • 4
  • 19

2 Answers2

1

David example is great! but if you don't want to miss those counts, you could do a calculated column where null values go to a 0 label

case when my_col is Null then 0 else my_col end
Eugenia Moreno
  • 31
  • 2
  • 1
    there are no null values, Superset with the Breakdowns property puts a slash for each existing attribute, if the SQL has no values it auto-completes it with null. the SQL does not return any null – Danieledu Aug 12 '20 at 04:56
0

You should be able to do that by adding a custom WHERE clause in order to remove null and 0 values from the display.
custom where clause

David Tobiano
  • 1,188
  • 8
  • 10
  • 1
    there are no null values, Superset with the Breakdowns property puts a slash for each existing attribute, if the SQL has no values it auto-completes it with null. the SQL does not return any null – Danieledu Aug 12 '20 at 04:56