Dynamic Ranking with Native Timescale




For a customer of ours I'm trying to build a dynamic ranking with the native timescale.


The 'regions' should be sorted from high to low based on a fixed line item but on the previous month.


Hope there is a workaround instead of manually sorting the values every month on the previous month in the dashboard.


Kind regards,


Best Answer


  • You can simply use the RANK formula in a line item and sort the display of the module by that line item.


    Now how to exactly do it, it depends how your module is displayed and how you can tell which month is the previous month, but I can't help you on that without more details.



  • Hi @HendrikDeCuyper 


    Do see if the following works:

    1. I've entered some random values for the different departments from Jan19 - Mar19.

    Screen Shot 2020-02-24 at 21.44.13.png


    2. Prev Value = Previous(Value)

    Use the standard sort from Lowest to Highest for 'Prev Value'.

    Screen Shot 2020-02-24 at 21.44.40.png


    3. Pivot the module such that time is along the page selector. When you select any time in the page selector, the departments are sorted dynamically based on 'Prev Value'.

    Screen Shot 2020-02-24 at 21.45.42.pngScreen Shot 2020-02-24 at 21.45.51.png