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ビュー
回答なし

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ