Forum Discussion
Lobs
Helper II
Helper IIRank 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
LobsHelper II
Helper IIYes, 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
Super User
Super UserHi 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