Suppress table row based on table calculation result?

ihayes
Participant III

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

0 5 688
5 REPLIES 5

Dawid
Participant V

Can you show us an example with the desired result?

ihayes
Participant III

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
Participant V

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
Participant III

Where is the “Hide nos from visualization” option?

moebe
Participant V

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

Top Labels in this Space
Top Solution Authors