Question

Measure filters don't apply to totals

  • 17 November 2022
  • 0 replies
  • 8 views

I have a Look similar to this one:

 

Customer (dimension) % of good reviews (measure) % orders reviewed (measure)
Customer name 1 15% 90%
Customer name 2 10% 1%
Customer name 3 20% 10%
Total 12% 85%

 

 

I have a “% orders reviewed” filter and I filtered by % orders reviewed > 15%. I would expect the total row to change, so it would be 

 

Customer (dimension) % of good reviews (measure) % orders reviewed (measure)
Customer name 1 15% 90%
Total 15% 90%

 

But it doesn’t change. It remains like:

Customer (dimension) % of good reviews (measure) % orders reviewed (measure)
Customer name 1 15% 90%
Total 12% 85%

 

 

I’ve read Looker documentation and I understand the “totals” row is calculated before the filter applies. 

 

It is ok… but I am really trying to find an alternative here…. My objective is to see how the “% of good reviews” changes when I apply measure filters (ex: % orders reviewed). I know I could do that using a derived table, but I would appreciate if there is any other alternative. 

 

OBS: This is just a simple example, my database is big 


0 replies

Be the first to reply!

Reply