Forum Discussion
TOPN with parameters & slicers
see attached for an approximation. Your "TOP 10" request is very complex, and may not be needed.
I am not aware of an automatic indentation option - you will need to traverse the matrix hierarchy yourself after you selected the filter granularity.
Thank you very much again!
It must be due to my bad English, but this is not what i'm looking for. Your table shows the max. value of rain for 1 day in jan.
What i'm looking for is:
How is a specific period (could be a single day, week, month, quarter or year) be compared to the top 10 of the same period in previous years.
Example:
The amount of rain on 15-01-23, how does it compare to the amount of rain on the same day (15-01) in the previous years. And show it in a bar chart with the top 10 results (years) desc.
Or,
The total amount of rain for december 2023, how does it compare to the total amount of rain in the same month (december) in the previous years. And show it in a bar chart with the top 10 results (years) desc.
Or,
The average max. temp for the month of june 2023, how does it compare to the the average max. temp. in the same month (june) in the previous years. And show it in a bar chart with the top 10 results (years) desc.
The period (date/week/month/quarter...) must be dynamic, so handled by slicer (not by filter).
Below a sample of how it should look like, beware this is NOT based on my data. Just to give you an idea.
Again many thanks for trying to help me out with this!!
Best regards, Rud.
Super Usersee attached for an approximation. Your "TOP 10" request is very complex, and may not be needed.
I am not aware of an automatic indentation option - you will need to traverse the matrix hierarchy yourself after you selected the filter granularity.
Many thanks for the response, and first of all I would like to wish you a good and prosperous 2024 and let you know that your words "it is very complex" makes me feel less stupid 🙂
I wasn't familiar with the 'include' yet, so I'm going to look into that further. Looks promising. Perhaps I can use it by creating a separate measurement for each item (mm. rain - avg.temp etc.) and combining that with a parameter and topN.
By the way, at the av. temp. the intention was not to add these up (sum) but to calculate the average (average), but that is a small matter.Many thanks again!!
Best regards, Rud.