0 votes
in Tableau by

Do we have any way to handle null values in Tableau?

1 Answer

0 votes
by

Tableau cannot plot null values on-axis. So, it will display an indicator at the lower right corner of the view. Once you click on that indicator, you have options to handle null values. Below are the options available to handle null values.

  • Filter Data – If you choose this option, null values will be filtered out from the view.
  • Show Data at Default Position – It replaces the null value with the default value and shows the data at the default position on-axis. These default values depend on the data type of field. Below here are the defaults of a specific data type.
  • Numbers →0
  • Dates → 12-31-1899
  • Geographic Location → (0,0)
  • Negative Values → 1
...