Hello!
Is there a formula which isolates ticket sales from the time of the event minus 2 hours? I can do it manually by isolating the hours, but hoping to have a solution which automatically updates based on the varied times for each event.
My hope is to create a line bar graph showing final sale for the last two hours for an event.
Thanks all!
Aaron
Hi Aaron,
This is the ideal solution: https://community.tessitura.com/ideas/i/ideas/enhance-tessitura-analytics-date-fields-to-include-time
But you might be able to compare the Order Hour to the Performance Hour. Some kind of...
SUM ( [Order ID] , SUM ( [Performance ID] , IF ( [Max Performance Hour] - [Max Order Hour] <= 2 , 1 , 0 ) ))
That worked great and yielded this graph.
Is there a way to automatically filter so only the time of the event, one hour before and two hours before show up? As you can see, although they are zero, values are showing up for hour 0 and hour 13.
See if a filter on the value itself will help. Try hovering over the value on the Values panel and clicking the funnel icon. Then filter by values > 0. If that doesn't do the trick, we can also try altering the formula itself to return a NULL instead of a 0 from the IF statement...
, 1 , NULL instead of , 1 , 0
, 1 , NULL
, 1 , 0