• Replies 5 replies
  • Subscribers 701 subscribers
  • Views 140 views
  • Users 0 members are here
Options
Related

Daily Ticket Sales 30 days out

Cristal Salow
$organization

Hello all,

I am trying to create a line graph in Analytics that shows the sales for a concert each day, for 30 days before the concert. I am hoping it's easy enough to change that to 14 before, 20 before, etc. I added to the X-Axis "Order Days Prior to Performance" (see image) and the numbers aren't right. I'm not sure what's actually being pulled.

I appreciate any guidance you can offer. Thank you!

Parents
  • $organization

    Hi Cristal,

    To debug I'd do one or more of the following.

    1. try it with a filter on just one show and see if that helps (in case the break by is messing you up*)
    2. Duplicate the widget and turn it into a pivot table.
    3. Start with one performance (I believe that they are single one off shows on a Sunday afternoon)
    4. Add a value line of # tickets sold and see if that matches Ticket Sales by Period
    5. Get really granular by adding customer number and display name in the Rows section and have a look at who bought tickets on a sepcific day (eg: 10 days out) and see if they match what you see in their customer record.

    *To be honest there are a couple of reasons that I have taken to using buckets over break-bys in line charts - especially with running sums.

    Hope that helps a bit.

Reply
  • $organization

    Hi Cristal,

    To debug I'd do one or more of the following.

    1. try it with a filter on just one show and see if that helps (in case the break by is messing you up*)
    2. Duplicate the widget and turn it into a pivot table.
    3. Start with one performance (I believe that they are single one off shows on a Sunday afternoon)
    4. Add a value line of # tickets sold and see if that matches Ticket Sales by Period
    5. Get really granular by adding customer number and display name in the Rows section and have a look at who bought tickets on a sepcific day (eg: 10 days out) and see if they match what you see in their customer record.

    *To be honest there are a couple of reasons that I have taken to using buckets over break-bys in line charts - especially with running sums.

    Hope that helps a bit.

Children