Hi all,
I need to pull only the tickets sold in our advance channels that are for the same performance day. So, in theory, order date = performance date for admission. Any assistance?
Thanks!
Nicole Lake tagging you
Hi Colette,
Try filtering on [Order Days from Performance] set to include only 0.
Thank you! We will try this.
This would be useful for us to but I am having trouble finding this. Which cube would the widget be set to? When adding the filter what is the field name that you add?
Thanks, Donald
Hi Donald,
In the Seats and Tickets cube; the SEAT & TICKET DETAILS dimension; Order Days Prior to Performance: For SLIs, the number of days between the order date and the performance date. In v16 this field is renamed to Order Days from Performance.
Thanks Chris! Seeing it now and getting the figure I need.