Forum Discussion

Lobs's avatar
Lobs
Helper II
5 years ago
Solved

Rank using Columns filtered by Month

Hi All,    So i am trying to create a column per metric that would rank our sites by month. Any care to give a sample on how i can do this?    This is what i have in a measure  Rank SC = RANKX(...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Lobs ,

     

    Consider following data and add an INDEX column to it as shown below in Query Editor:

     

    Now create a Rank column as follows:

     

    Now move this to the table visual as below and Rank calculated above:

     

    As you haven'e shared the expected output, Is this what you are expecting?

     

    Thanks,

    Pragati

     

Lobs's avatar
Lobs
Helper II
5 years ago

Sorry about that, here is the sample of the data im working on. Im just trying to rank them by Month, without using a measure. 

 

MonthSiteMETRIC ScoreRank
1/1/2020Loc 1 100 
1/1/2020Loc 298 
1/1/2020Loc 399 
1/1/2020Loc 475 
1/1/2020Loc 597 
1/1/2020Loc 685 
1/1/2020Loc 784 
1/1/2020Loc 8100 
1/1/2020Loc 950 
1/1/2020Loc 1051 
2/1/2020Loc 1100 
2/1/2020Loc 298 
2/1/2020Loc 399 
2/1/2020Loc 475 
2/1/2020Loc 597 
2/1/2020Loc 685 
2/1/2020Loc 784 
2/1/2020Loc 8100 
2/1/2020Loc 950 
2/1/2020Loc 1051 
  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi Lobs ,

     

    Do you want to rank your rows on MONTH column?

    If yes, then on what other column - METRIC?

     

    Can you share the expected output also?

     

    Thanks,

    Pragati

    • Lobs's avatar
      Lobs
      Helper II
      5 years ago

      Yes, by month using the Metric Column. The out on these columns will be used on the KPI indicator visual which will be filtered by Site. 

       

       

      • Pragati11's avatar
        Pragati11
        Super User
        5 years ago

        Hi Lobs ,

         

        Consider following data and add an INDEX column to it as shown below in Query Editor:

         

        Now create a Rank column as follows:

         

        Now move this to the table visual as below and Rank calculated above:

         

        As you haven'e shared the expected output, Is this what you are expecting?

         

        Thanks,

        Pragati