I have a pivot table with main dimension and dates.
I’m trying to find a way how to highlight smallest/biggest values for dimension over periods.
On screenshot you can see an example.
What should be in this case for ROW, on week '’2022-11-28" value should be in fully red, on week ‘’2022-11-07’’ fully green.
Right now Looker highlights smallest/biggest values based on Column, not on Row
Appreciate any ideas how to do this.