How would I get the % of orders for General Admission that included an add-on donation (set to a specific fund)?
When in the Finance cube, the total number of orders it gives for this year (defined by transaction date) is 4,379.
When in the Seats cube, the total number of orders it gives for this year (for timed admission) (defined by performance date) is 33,254 (29671 for 22Timed Admission).
When in the Contributions cube, I can't look at order ID- the total number of contributions it gives for this year (defined by contribution date) is 5,041.
There certainly have been more than 4379 orders for General admission, so I'm not sure what is depressing that order count. How would I combine the three cubes to figure out what I need?
Hi Nathanael,
I would expect this to be achievable in the Finance cube, but only for a % of orders with money against them that have an add-on donation. Comp orders won't be in the Finance cube.
Is it possible that the orders that aren't in the Finance cube could contain only $0 tickets, excluding them from the Finance cube? Or that there are filters not quite aligned with the Seats and Tickets cubes? Do they align better using performance date instead of transaction date in the Finance cube? Is your total number of orders a [# unique Order ID]?
In the Finance Cube, if I filter only by 'Transaction Year' = 2022, I get 26,434 order IDs (unique Order IDs). When I bucket that for (fund = add-on online donation), I get 3,477 order IDs. That is a number, but I don't know how to be confident that it is a correct number.
If 3477 is the total number of orders with a fund of 'add-on online donation', that that is a useful number- I can check that against total number of orders, and that's my percentage.
How would I tell the Finance cube "Show me all the order IDs with a production season of Timed Admission?"
You can do something like this: (+) Loss Leader Pricing - Reporting & Analytics - Forums - Tessitura Network
Using Order ID and orders with that fund (instead of a given price type as in the example).
I've bucketed for Price Types containing 'ETIX', which gives me a total # of Orders 15,907. This seems to say that there have been 15,907 Orders containing ETIX price types (not including comp price types only).
However, the bucketing for 'Orders where fund = add-on' always shows (none) for the price type row if I add it in. Does this mean that it's separating all 'Order IDs where fund = add-on' from any 'Order IDs where Price type = ETIX'?
I know that all orders with an add-on also had ETIX, because that fund is only used to round-up orders through the web. There wouldn't be an add-on without an ETIX.
I read this as:
Are these the only price types in 2022? Are you expecting to see add-on associated with those 102 summer camp orders?
The snip was just to illustrate the (none) in the Price Type row. The add-ons would only be associated with timed admission price types, which is why I'm uncertain why there are transactions with the add-on fund, without any price types associated with them
If you put Order ID between Year and Price Type, it might become clear. All of the contribution transactions toward a fund will be associated with the (none) price type.
I think I'm getting some clarity. The Order IDs (bucketed to 'fund=add-on') will never display as having a price type attached. Some of those those Order IDs do in face have Price Types within them, but the Finance Cube won't display them as being in both columns (fund = add-on and price type = ETIX).
1989718, for instance, is an order with an add-on donation and an ETIX price type.
Given that, the formula that shows me (fund = add-on) and the formula that shows me (price type = ETIX) are both accurate, but there is some overlap, some double-counting. All the add-on orders are by definition ETIX orders, but all the ETIX orders are not by definition add-on orders. For my purposes, the add-on orders divided by the ETIX orders would give me the % of add-on orders for ETIX.