Hi All,
Looking for some help with a histogram / bar widget in Analytics.
I’m looking to get a widget which buckets orders by the number of tickets in the order. I have an average tickets per order but want to compare the avg. against actual and occurrence.
I've had a look at the community and bucketing webinar, but am struggling with formula / syntax. Any help would be greatly appreciated.
Cheers,
Amy
Barking Gecko Theatre / Arts & Culture Trust (WA)
Hi Amy,
For each bucket value formula... (starting with a count of orders containing exactly 1 ticket)
SUM ( [Order ID] , IF ( [Total Ticket Count] = 1 , 1 , NULL ))
However, this will be impacted by any product filters. So if the widget is limited to a certain production, this will return a count of tickets in the order for that product. If you need to filter to a product, but still want to count total tickets in the orders that contain any tickets to that product, then something like...
SUM ( [Order ID] , IF ( ( [Total Ticket Count] , ALL( [Production Season] ) ) = 1 , 1 , NULL ))
Hopefully that gets you underway.Best,Chris
Thank you so much Chris - I've been able to get this data now. Next step - integrate the average no. of tix / order! I was also talking to Heath Wilder about it, and he suggested looking at SLI (or number of subline items) but this is very clear. Cheers!Amy