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

posta un anno fa69 visualizzazioni
Nessuna risposta

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande