QuickSight - How can I visualize event ticket sales YoY with different event dates?

0

Hi, I'm working on a ticket sales dashboard in QuickSight (using a csv file that I will regularly upload). Once a year we host an event for which we are selling tickets. To better understand how we are doing in terms of ticket sales, we would like to compare ticketsales for the upcoming event to ticketsales from previous events. However, while in 2021 the event happened in September, in 2022 it took place end of June and in 2023 it will take place mid of June. So instead of tickets sales by respective month YoY, we would like to have something like -20 weeks to event, - 19 weeks to event, etc. on the x-axis, and compare all events within one chart. So always working backwards from the respective day of the event. Is that actually possible? :/ Many thanks, Axel

已提问 1 年前69 查看次数
没有答案

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则