I need to create a visualization in which I can see which item from my list is the oldest. I have tried it with a blend but I can’t seem to find a way to filter the row in which the age is equal to its maximum. How could I achieve this?
Sort by age and set the row limit to 1?
In Looker, the easiest way to solve this would be to include the age dimension and sort on it descending. That would give you the maximum age. Then you could hide that dimension, display the name dimension, and set the row limit to 1. That way Looker would only display the name corresponding to the max age.
But I noticed you mentioned blends, so you may be using Looker Studio. If that’s the case, I don’t think you can hide dimensions. I’m not sure how you’d solve this in Looker Studio!