Hi Team,
I'm trying to see, from 2018 to now, how many households purchased tix, and of that number, how many also made a gift. In Analytics - using the Seats & Tickets cube to get ticket information as well as contributed dollars - I'm creating a Bar or Column chart with Categories set to Season, Values set to # of unique constituent ID's, and then I want the Break by sections to be Tickets Only vs Tickets + Contributions. Is there a filter that's simply Tickets? = Yes and Contribution? = Yes ?
Thanks for the help.
Sara
Hi Sara,
When you say "also made a gift", do you mean within the same order as the purchase, or just generally made a gift at some time? In the former case a lot of it will depend on your configuration and processes, and you will likely need to use a different cube (see Nathanael's post for an example). In the latter case you many be able to use either the contribution info supplied in Seats and Tickets or you might want to use Analytics enabled lists (if so, be aware of this caveat).
--Gawain
Hi Gawain,
GREAT Q. I am indeed speaking about the latter. In 2018, I want to know people who purchased tickets at some time and also gave a contribution at some time, not necessarily together. I'll jump back in and create a list of what I'm looking for - in fact it makes more sense in my brain to pull a list of to find this, but I need a visual representation to present to others - and see what it does when enabled for Analytics. Thank you for that idea.