In the scenario, “Top 5 cities with the highest weekly temperature over the last 90 days” can be interpreted two ways:
Option 1: Top 5 cities with the highest average of temperature over last 90 days, displaying theirs temperature each week.
Option 2: Each week’s top 5 cities with the highest average of temperature, displaying the temperature each week for the last 90 days.
See the differences between these two options below.
In the Buckets panel, the city.keywork has higher priority than timeStamp.
The chart result shows weekly temperature of only 5 cities that have the highest temperature over the last 90 days.
In the Buckets panel, change the timeStamp to have higher priority than the city.keyword.
The chart result includes weekly temperatures of different cities. The top 5 is different week-to-week, so there are more than 5 cities in the legend.