• Replies 1 reply
  • Subscribers 960 subscribers
  • Views 197 views
  • Users 0 members are here
Related

Analytics - Comparing 2 productions' revenue, x weeks out... help!

Matthew Nemik
$organization
Hi everyone,
I've been messing with this widget for a little while without much luck, so I figured I would ask you all!
Basically, I'm trying to plot a line chart of our theater's total sales for a production x weeks before its opening date and compare that to a similar production from last season. What I have is close (?), but not quite there.
  1. Right now, the chart is looking at each individual performance of the 3-week run rather than just the opening day. This means it's comparing the last production's total revenue--through the entire run of the show--with our current, pre-opening, revenue for the upcoming production on the same "week."
  2. This would be a decent visualization for comparing productions that have already passed, but isn't super useful for the sort of forecasting/snapshot widget I'm wanting to create (and it makes our sales look pretty dire, which is fun).
Is the sort of widget I'm looking for possible? Again, this would be a widget that looks at all of a production's revenue, counting only orders done before the first performance of each production, and then plots that in a way where we can compare revenue in the weeks leading up to opening day of each production. Ideally, this would be a chart or something visual and easy to look at, but I'd be happy with anything at this point.
Please let me know if you have any tips or have created a similar widget--I'm all ears!

Parents
  • $organization

    Hi Matthew.  I think that I have had this same issue for a while now and have not had any luck.  With these running sum (hockey stick) sales charts you can do Days since onsale (onsale being first MOS startdate which you have) or days before performance, the latter also not being helpful as it skews the result based on a relative date the orders performance.  What I'd love is Final Performance Date - Order Date (ie: days prior to closing).  For that I'd need a new column in BI.VT_Order_Details on the Sub Line Item.  I managed to make a basic version of this in SSRS but not in Analytics.  If I manage to work it out I'll let you know but I've received head scratches all around.

Reply
  • $organization

    Hi Matthew.  I think that I have had this same issue for a while now and have not had any luck.  With these running sum (hockey stick) sales charts you can do Days since onsale (onsale being first MOS startdate which you have) or days before performance, the latter also not being helpful as it skews the result based on a relative date the orders performance.  What I'd love is Final Performance Date - Order Date (ie: days prior to closing).  For that I'd need a new column in BI.VT_Order_Details on the Sub Line Item.  I managed to make a basic version of this in SSRS but not in Analytics.  If I manage to work it out I'll let you know but I've received head scratches all around.

Children
No Data