I'm trying to display only the latest 5 weeks on a straight table but when I use the 'Fixed number' top 5 It give me a result based on the next column measurement.
My goal is to show the latest top 5 weeks (the most recent ones every week) independently of the measurements. but if a try max(my_date) or similares it says invalid dimension. Any idea of how to sort this out? Thanks.