Tip: How to filter a table calculation

Hi all,

I didn’t find this in the forums, but I figured out an easy workaround so I thought I’d share.

Say you want to filter a table calculated variable called CalculatedOrders, and only plot where CalculatedOrders>3

All you need to do is to create a new new table calculation called FilteredCalculatedOrders:

if(CalculatedOrders<=3, null, CalculatedOrders)

Then, once you have your plot, go to the Edit label and turn off “Plot Null Values”

Hope this helps 😄

Thanks to @Alejandro_Aguil from support for help with this one!

2 3 5,942
3 REPLIES 3

As of version 3.28, it’s now possible to filter visualizations via table calculations by hiding No values from a table calc that returns Yes or No! Read more about how here.

2 posts were split to a new topic: Filter table visualization with table calc?

Shru
Participant III

2 posts were split to a new topic: Filter table visualization with table calc?

The link gives an error. Please check

404— Page not found

SELECT 404 AS the_error,

'Uh oh! It looks like you found a broken link. You can let us know at community@looker.com' AS the_apology



FROM looker-community.errors errors
Top Labels in this Space
Top Solution Authors