Forum Discussion
Rank over Project considering the defined date range
Hi, I would like to display the ranking of a score (distance Kerstin to first place) over all competitors for a project and then rank them based on the value considering the date. I have made a ...
I would like to display the ranking of a score (distance Kerstin to first place) over all competitors for a project and then rank them based on the value considering the dateNo idea what you mean by that. Can you show an example of the expected outcome?
Why is the Competition field hard coded with a rank?
At first I would like to achieve a ranking over the narrowed date range. There are 27 projects in the November 2022 time period: Ranking 1-27.
Based on this, I would like the matrix to show me only the projects with values 1 and 2.
However, if I set the filter to the visual, I get an empty matrix. It seems that the filter context does not take into account the narrowed date range and so, for example, the project with rank 1 for November 2022 gets rank 35 for the entire period.
Thanks
Chris
I think you will want to read this article.