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!
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?
2 posts were split to a new topic: Filter table visualization with table calc?
The link gives an error. Please check
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