Please post .twbx file. This would help us in solving your problem.
Sorry, can't do that
I think that's what I want. But I can't figure out how to do it
so the rank formula is -- RANK(sum(Unique Count)). Let me know if there are other issues in doing this.
Thank Anuvir. Now I have a new problem.
So I tried the rank formula and it works with my other graph
For this graph I don't have to rank them within the months. I just to rank and sort them so I only see the trend of the top N.
As you see in the picture. I've filtered Rank to show just the top 2 trends but for some reason an extra point shows up. (The pink dot near April)
The problem get worst when the range gets larger
I need to show the same number of trend line as the range selected. No extra dots
Any suggestion? Thank you