Creating a Cumulative Ticket Sales Chart for Annual Festivals with Varying Event Dates

0

I need assistance in analyzing ticket sales data for a festival that occurs annually with varying event dates. The festival generally takes place in June, but the specific dates differ each year, and there was one instance in September. The dataset spans 5 years, and ticket sales commenced at different times for each festival.

I want to generate a chart that compares cumulative ticket sales across all five festivals over time, with the timeline working backward from each event date. Ideally, I'd like to have a separate line on the chart for each festival, illustrating the cumulative ticket sales leading up to its respective event date (similar to the sample chart attached).

Is it possible to create such a chart, possibly using parameters for the event dates? If so, could you provide guidance on how to achieve this?

Thank you for your help!

Sample Chart

gefragt vor 3 Monaten58 Aufrufe
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen