Dearest Friends,
My mission--find and assess the number of tickets acquired by a specific payment method for any given ticket season. I've done a little digging and have the payment method numbers I need, and it seems they all reside fairly plainly in the T_PAYMENT system table.
While I know there are reports to find out the total dollars for any given payment method, what I want to ferret out are number of tickets moved with a payment method in a given season and compare it to another. T_PAYMENT provides the payment methods, but I'm curious if anyone has any tips on how best to tie it together with season and ticket counts?
Any thoughts, feelings, or inspiration otherwise that you have to share is much appreciated!
Thank you,
Brian Jones
It is never clean but from t_payment you can join to T_Transaction (use transaction_no and sequence_no) and from there you can get the order number (if there is one as may be a contribution etc)
The issue you have is that if multiple payment methods are used in a single order as then you potentially start double counting tickets.
You may need to do this in two stages - one where you amalgamate the payment methods used on an order ie 'Gift Voucher/Mastercard' and then using that calculate the tickets bought.
Mark