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?
@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!
@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!
בתאריך יום ג׳, 7 במרץ 2023, 19:14, מאת Sagnik Mukherjee via Amazon QuickSight Community <firstname.lastname@example.org>:
Thanks @Eldad_Levi for marking as “Solution!” It really helps our community to know that this worked for you. Thanks @sagmukhe!