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
@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! 