Knowledge Drop

How to hide/filter certain values from visualization

Userlevel 2

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.

doc available here


This content is subject to limited support.                




0 replies

Be the first to reply!