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

asked a year ago66 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions