Hello!
So I have created two widgets. One which shows how many tickets we are selling week on week for a given show. The other one shows currently how many tickets we need to be selling per week in order to hit capacity for that show.
I would like to combine the two widgets into one graph with dual axis if possible? Columns which show the weekly number of tickets sold and then a line which shows the current weekly number of tickets we need to sell to hit capacity.
See the current 2 widgets below and the formula used to get the weekly number of ticket sales required to hit capacity.
thanks!
My first thought is to have both formulas in place on that one column graph, and set the 'capacity' formula to display as a line.
The capacity will be static for each performance, so it will display as a flat line, and the actual number of seats sold will vary by performance.