Haia all
Hoping someone has a magic solution to this one...
We have imported our visitor figures in to Tessitura and I'm looking to show donation per head, so looking at contributions on a specific constituent against the number of tickets booked during that month. (Each museum has it's own constituent).
I know this is affectively mixing Seats and Tickets cube and Contributions cube, but is there any chance this is possible in one widget? Without me having to update it manually?!
It would be a Contribution Amount (Sum filtered by Fund) / Ticket sales (Sum) for a particular constituent in a particular month
All thoughts super welcome!
Thanks all,
Kirsty
Hi, Kirsty - Would it be possible for you to use the finance cube? It doesn't have ticket count but it does have ticket dollars so not quite a magic solution but maybe a possibility. Good luck!
Thanks Madeline, unfortunately our tickets are free and there is no seat count in the Finance cube, I thought you were on to a winner there!
Do you add a constituency to accounts that have visited the theatre? I was able to figure this out in my system just now using the finance cube and constituencies. But we add a constituency for each fiscal year for single ticket buyers and a separate one for subscribers. Let me know if you think that would work for you and I'll send you the screenshots and formula details.