Dynamic Ranking with Native Timescale

HendrikDeCuyper
HendrikDeCuyper
in Modeling

Hi,

 

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,
Hendrik

Tagged:

Best Answer

Answers

  • nathan_rudman
    nathan_rudman

    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.

     

     

  • LipChean_Soh
    LipChean_Soh

    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

     

    Thanks,

    LipChean

Categories