Forum Discussion

Lobs's avatar
Lobs
Icon for Helper II rankHelper 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
Icon for Helper II rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper II rankHelper 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
      Icon for Super User rankSuper 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