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