So right here I have a list of Client Type ranked by volume in descending order. I want to add a new column on the left of it to indicate the ranking 1-10, if I use SQL, then I wouldn't be able to use the date filters that I have set for my dashboard. What should I write for the Custom Column to make these rankings?
There is no rank function in the custom columns ... but if you use field filters then you should be able to use SQL and link questions to dashbaords: