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.