I'm looking to report in Analytics on donations that came in via our TNEW cart donation ask path. A couple of weeks ago on a call, a suggestion was made to use the finance cube to find this information by filtering it to show any contributions with an order ID > 0. This works really well if you're trying to show in total what came in. What I would like to do is show this information based on what performance they also had in their order and short of a list that generates each night with ticket history I'm out of ideas on how to show this! Anyone run into this and have a solution?
That's a potential many-to-one relationship that Analytics typically can't handle.
To put it another way, if a customer buys tickets to Performance A, Performance B, and gives a contribution, which performance is credited with the contribution?
That's valid. I guess what I really want is if they had x in their order and donated. It's okay if they had other stuff in their order too.
I haven't done much of any work in the Finance cube, but could you look at contribution amount, then add in something like 'Performance Code' as a filter as well?
My thought (might not be a good one) was to have Widget Filters for things with Order ID > 0, and Constribution Amount > 0, have 'Values' set to Debit/Credit amount ( I can't remember which one's which, tbh), and have 'Rows' be Performance Code and/or Order ID?I don't know if that's helpful, but maybe if you started from a different vantage point and worked backward, it might come together.