Top N filter by each day in the graph

Hey,
I tried to filter the top 3 filter and filter on each day in the graph to top locations of impressions.

Unfortunately, the filter calculate the top 3 locations all over the period in the graph (7 days) and presents their performance on each day.

Is there a way to present the performance of the top 3 locations on each day with that filter?

Best,
Eldad

@Eldad_Levi, Try to create a calculated field using the rank or dense rank function (based on your need) to assign rank to each of the row at a day level. This means use day as the partition key. Then put a filter to include only the rows having value of 1,2 and 3 for that new calculated filter. Hope this helps!

1 Like

Thanks a lot! it worked

1 Like

@Eldad_Levi - Good to know that. Would request you to mark the relevant post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!

1 Like

Yes thanks

בתאריך יום ג׳, 7 במרץ 2023, 19:14, מאת Sagnik Mukherjee via Amazon QuickSight Community ‏<noreply@community.amazonquicksight.com>:

Thanks @Eldad_Levi for marking as “Solution!” It really helps our community to know that this worked for you. Thanks @sagmukhe! :slight_smile: