Knowledge Drop
Last tested: Sep 21, 2020
Certain visualizations, i.e. line, scatterplot, area, have the "Plot Null Values" option in the visualization section. We can leverage this along with table calculations to exclude certain values from a visualization.
We can do this by creating a table calculation that uses an if() function to assign "null" to values that we would like to exclude from the visualization and then toggling on the "Plot Null Values" setting.
This is useful because if we were to simply filter on the field where we'd like to exclude a certain value, we would filter out all rows where that value resides. This method preserves the values in the columns in the row.
LinkedIn
Twitter