Hi Everyone,
I want to look at the data on a dashboard prior to when the show was canceled and we started issuing refunds. I know Analytics refreshes every night. Is there a filter or way to do this in the Ticket/Sales cube? Thanks!
Hi Nicole,I'd use the "Order Date" function in the seats and ticket cube. Then just filter the widget to all dates prior to whenever you started issuing refunds
You could use the Transaction Date field in the Finance Cube to see how the money part looked. Too bad that Transaction date is not available in the Seats and Tickets Cube.
Thanks. I initially thought of and tried that. I suspected that it would return the same information on tickets that haven't been refunded yet because it's looking at the revenue as of the refresh date. I also tried filtering in SLIs to see if it would count the revenue of returned tickets, but that didn't work either.
Thanks. Yeah, that's a bummer. As I mentioned above, I tried using an SLI filter but that didn't work either.