Hello,
So I am looking to track sales over time (by order date) broken down by zones in our theatre.
I can create this line graph easily, but as we use micro-zoning in our seat map setup, I have up to 4-5 micro zones within our raised stalls zone for example.
Is there a way to group and total all the micro zones within our raised stalls (for example) to give a running total for the raised stalls as a whole?
I hope that makes sense!
Cheers
James
Hey James,
I'm assuming that your Zone Groups won't help in this instance but you can group these together into buckets of Values with a filter ( sum([Ticket Count]) , [Zone1] )
1st widget is ticket count by Zone
2nd widget is buckets of Zones (I only did 2)
Inside the second widget
Editing the first Value
You can take that final pivot and turn it into a line graph with Order Date as the X-axis
This absolutely worked... Thanks Heath!
Glad to help