T-Stats: Specify Order Dates as Date-Time

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,

Sam

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,

Sam

Hi Sam, 

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.

Tatiana

Hi Sam,

Just wanted to add two thoughts on the T-Stats approach:

1. Order Hour is standard in T-Stats v3. Have a look at Tickets cube / Ticket Orders / Dates / Calendar and see if you see Order Date - Hour in there. If not, then you'll have it after the Southbank upgrade to v3 is complete, which I know Moira has been working toward.

2. Using your sample dates, you could, though I realize it's not the prettiest thing, report on10/6/2013 00:00 thru 12/05/2013 11:59 in one report (essentially by not filtering out any Order Hours), and then have a second report that showed 12/06/2013 from 00:00 thru 10:00.

Hope that helps. Best,
Chris

Hi Chris,

Thank you for the heads up Re: v3 - I'll have a chat to Moira about it. Your suggestion in number 2 is a good workaround, but ideally I'd like the report in one. 

Thanks,

Sam