Hello,
I have created a simple cumulative sales over time line graph with 'Order Date' on the X axis and a running sum of 'Total ticket paid amount' as the line.
Because we dynamically price, our gross potential is always changing. I'd like to add a dynamic horizontal line to this graph which shows the current gross potential for the production. I assume that would be 'seat unsold value' plus 'ticket paid amount'. But because the x axis is 'order date' this obviously won't let me add a gross potential horizontal line because it's looking at each day.
Is there any way to produce such a line on this graph?
Thanks!
Hi James,
You could use [Seat Current Base Value] for all seats across all order dates...
( [Total Seat Current Base Value] , ALL ( [Days in Order Date] ) )
One issue here is that you'll be penalized by seats that sold prior to a price increase, so you'd probably want the base value of the seat at the time of sale. Something like...
( [Total Seat Current Base Value] , [Seat Sold Flag = N] , ALL ( [Days in Order Date] ) )+ ( [Total Seat Order Date Base Value] , [Seat Sold Flag = Y] , ALL ( [Days in Order Date] ) )
Thanks Chris!
This worked!
Would you share that James? I think that is exactly what I am looking to produce.
Hi Jen,
Not shared a dashboard before but try clicking on this > Cumulative Sales Graph
The '£ capacity' line should show the overall financial capacity
The '£ current achievable' will show the current achievable capacity. For example, if you are halfway through a long running production with empty seats left in the past, this line will show you what the current achievable financial capacity is. So it's basically total sales PLUS remaining available financial capacity.
Hope this helps!