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

     

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