Hello!
I am a Tessitura analytics newbie. I am trying to create a sales curve graph with the number of tickets sold in the last two weeks leading up to an event. When I filter for 14 days prior to the event, the ticket count starts at 0. Is it possible to have the ticket count begin at the amount of tickets which were previously sold? In the example below, the second graph should start at 178 tickets instead of 0.
Thanks so much!
Here is a graph of all sales:
Here is a graph of the last two weeks leading up to the event.:
Mark Levine Is the ticket count starting at 0 for 14 days before? When I do 2 weeks to the performance date, the ticket count starts at 0 instead of including the tickets purchased prior to 2 weeks before the event. Chris Wallingford Thoughts?
Oh, I see the issue. My report is showing sales per-day and you're looking for sales-as-of. I should have realized you wanted to see a SUM (as that's what I wanted too), I gave up with a sad face because I don't think there is a way to get it to work. Sorry
I had the same misunderstanding as Mark. Apologies for that. We can update the formula with ALL([Days in Order Date]) for the two end points of the curve. This will override the Order Date grouping on the X-Axis for those two points.
ALL([Days in Order Date])
RSUM ( CASE WHEN MAX( [Order Days Prior to Performance] ) = -14 THEN ( [Total Ticket Count] , [Order Days Prior to Performance <= -14] , ALL([Days in Order Date]) ) WHEN MAX( [Order Days Prior to Performance] ) = 0 THEN ( [Total Ticket Count] , [Order Days Prior to Performance >= 0] , ALL([Days in Order Date]) ) ELSE [Total Ticket Count] END)