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

preguntada hace 3 meses58 visualizaciones
No hay respuestas

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas