This content has been marked as final. Show 2 replies
So I'm trying to build a view which shows ranking development over time (Ranking is a measure, not a table calc or calculated field).
Since there are up to 200+ Products in the view the line chart I am using gets very crowded. For that reason I want to let my customer choose 1 product, and have the view display the line for that product and the 5 closest products rated higher and lower than the selection.
So in other words if the selection is Product Z, which has a ranking of 21 (at the latest available date), then the view needs to show Product Z and the products ranked between 16-26. I've illustrated the goal below:
Can anyone point me in the right direction for making this work?