• Replies 3 replies
  • Subscribers 961 subscribers
  • Views 140 views
  • Users 0 members are here
Related

Grouping in analytics?

James Davis
$organization

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

Parents
  • $organization

    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

Reply
  • $organization

    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

Children