Forum Discussion
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(...
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
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.
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