I am using compare table in lens and using ranking functionalty to rank reps according to their attach rate perecentage. However it does not rank correctly. For an example column C is attach rate and Column D is rank. If my attach rates ofr different reps are 0.89%, 1.3%, "-".Then it ranks "-" as 1, 1.3% as 2 and 0.89% as 3. Whereas it should be 1.3% as 1, 0.89% as 2 and "-" as 3. Can anybody help me?
2 个回答
Hello Jay,
I advise you to create a new column to manage the null case "-". You can use the coalesce function like that coaslesce(C,0) and then try to apply the Ranking function on this new column.
It should work fine after ;)
