Hi all,
I'd like to be able to specify a date-time range for Ticket Orders in T-stats, so that I can report on priority booking ticket sales up to 10am at the end of the priority booking period.
Does anyone know if this is possible?
Thanks!
Sam
Hi Sam,
Have you tired the parameter in the Ticket Order Dimension?
Open Ticket Order/Dates/Calendar/Order Date - Hour
Then drag it up to the Filter/Slicer. Open the All menu. there you can filter out the hours of the day you want to see or not see.
Hope this helps.
Tatiana
Hi Tatiana,
Thanks! Are you working in the Tickets cube? I don't think our T-stats set up has that level of granularity but it's good to know that it can be enabled.
What I would like to do is filter orders like so (for example):
Order datetime start: 10/06/2013 00:00
Order datetime end: 12/06/2013 10:00
So rather than look at sales between, say, 10:00 - 11:00 over a range of days, I want to specify my range with greater precision (e.g. the above example I'll have sales for the whole day on 11/06/2013, but only up to 10am on 12/06/2013).
Can you do that with your set up?
Thanks,
Yes, I'm in the Tickets cube.
No, the granularity only extends to each hour.
What if you use the Performance Transaction Detail report?
If you enter the date range for only the 1 day of your event, it'll give you all of the tranactions for events that day. The actual run of the report only shows the date, but if you save it as a csv file and open it in Excel, the date cells include the exact time. Then you can sort by date and you'll be able to see the exact minutes of the sales.