Is it possible to suppress a row in a Looker table using a table calculation column value?
Can you show us an example with the desired result?
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%
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
1 Like
Where is the “Hide nos from visualization” option?
Click on the Column you want to hide.
There is Hide from Visualisation
1 Like