Suppress table row based on table calculation result?

[ihayes]

Is it possible to suppress a row in a Looker table using a table calculation column value?

[Dawid]

Can you show us an example with the desired result?

[ihayes]

I have a simple table report that shows web site sessions by date. There is a % change column that is a table calculation. This calculation uses the offset function to compare each date row with the average values for the day of the week from the previous four weeks.

I want to suppress all rows where the “% change” value is either null or not between -20% to +20%

[Dawid]

By surpress, do you mean stop them being displayed in the visualisation?

If so you just need a table calc called Show (that’s how I name it) and then use NOT(is_null(${percent_change_previous_4_weeks})) and use this calculation as Hide Nos from visualisation

[ihayes]

Where is the “Hide nos from visualization” option?

[moebe]

Click on the Column you want to hide.
There is Hide from Visualisation