Hi Everyone,
I'm trying to pull in transactions between a range, but it's not the entire day. I'm looking to get transactions for a 48-hour period beginning at 4PM one day and ending at 4PM two days later. It's 4PM on 11/27 through 4PM on 11/29.
I've got the date range in the date filter selected. That was easy. Do I just add a timestamp to the end? If yes, how do I format that?
What you could do is create a pivot table the includes Transaction ID and Order ID. You then figure out the beginning and ending Transaction ID numbers that fit within your 48-hour window by loading the order and clicking on Order History to figure out the transaction time. You then add a filter on Transaction ID. Does that make sense?
This is a good idea, but it doesn't quite work for this situation since a lot of gifts that were received within the timeframe weren't entered until after. I can backdate the gifts on the gift date and the post date, but the transaction IDs will just carry on sequentially.
Hi Allison,
Given Neil's idea isn't going to work for you, and that there isn't an "Hour" field in Analytics Finance for Transaction Date as their is for Performance Hour, I don't think you'll be able to get there with Analytics. This idea is on the roadmap as the next, biggish Analytics data enahncement though, and should help at some point in the future.
Enhance Tessitura Analytics date fields to include time - Ideas - Ideas - Tessitura Network