• Replies 2 replies
  • Subscribers 962 subscribers
  • Views 191 views
  • Users 0 members are here
Related

Histogram / Bucketing - Sales by Tickets per Order

Amy Welsh
$organization

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)

Parents
  • $organization

    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

Reply
  • $organization

    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

Children