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

已提问 3 个月前58 查看次数
没有答案

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

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

回答问题的准则