2 Replies Latest reply on Aug 27, 2018 12:37 AM by daniel.braw.1

    Show fixed number of entries above and below selection

    daniel.braw.1

      Hi all,

       

      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?