Question

Filtering by Calculation columns

  • 29 January 2018
  • 16 replies
  • 2084 views

Is it possible to filter by table calculations? I have a simple calculation at the end of my row that shows the highest value in the row (hundreds of data points). Now I want to filter on that calculation and only show rows with values above a certain threshold. How would I accomplish that?


One note, I have seen the method to filter “No’s” from visualizations but that won’t work in this instance. I need to pair down the data I’m working with before I go into visualization. My database would produce tens of thousands of data rows in not filtered first.


16 replies

Userlevel 2

Hi @Michman


It is not currently possible to filter on table calculations (outside of Hide "No"s from Visualization discussed in this Discourse), but I will let the Product team know that’s something you’d like to see!


In this use case, it sounds like the best option would be to define the table calculation as a measure, and then filter on that measure. Please let me know if you have any questions on this!


All the best,


Emma

Looker Support

Userlevel 3

+1 vote… need to be able to do this for top 10 say

Userlevel 6
Badge +1

Top 10 could be achieved by having yesno dimension calculated based on a table calculation with row(). The row() stays the same regardless of the order, hence you can first order and then take top 10


Or use the visualisation settings to only display n rows

It would be really helpful if we could filter on table calculations directly without having to create a measure.

I agree it would be extremely useful to filter by a calculation column.

Hi there,


Did anything been implemented regarding this topic ?

best,

+1 - Agree it would be so useful to have the option to filter on calculations; thank you!

Userlevel 1

+1. This would be a very useful feature

Userlevel 6
Badge +1

Filters work in SQL layer that’s why we can’t use it. Since table calculation is in the client layer you can create another yesno type column and use it as Hide Nos from Visualisation

+1. This would be a very useful feature

Another +1 here for this feature

+1 Would be a very helpful feature.

+1 on this feature, run into this problem a lot

+1

+1

+1. very important feature

Reply