I have been trying to pull three things -
1. People who have bought the most tickets within a time frame.
2. People who have gone to the most shows within a time frame.
3. People who have spent the most on tickets within a time frame.
I have tried going about this various ways via List Manager, using Tickets - Number of Seats (for #1), Ticket Unique Perfs Household (for #2), and Tickets - Total Amount (for #3).
I have also tried using T-Stats, using Const Sum - Tickets - Num Perfs Attended in Past Yr (for #2) and Const Sum - Tickets - Total Ticket Purch Range (for #3).
Each time, when I output the information, and add up the tickets, or shows, or amount spent, the outcome doesn't match my criteria. For example, if I asked for people who attended more than 20 performances in a certain time frame, it gives me people who have attended 3, or 12, etc. Or, if I asked for people who spent more than $5000 on tickets within a certain time frame, it gives me people who only spent $1200, or $3000, etc.
I have limited it by price type (don't want to include comps), and season for my time frame (only am asking for the past 3 seasons. I also haven't included our Education shows, as those are bought by teachers for their classes and would skew the numbers.
I'm not sure what I'm doing wrong with this....any help would be soooo appreciated!
I have seen similar issues but is normally due to the fact you are pulling data from multiple tables or that your criteria is not all being applied at the same time - ie you could be finding everyone who has bought a ticket for those 3 seasons at the price type who has also attended more then 20 performances ever.
I tend to use Manual Edit to verify the SQL, but that is because I am familiar with SQL, which will normally highlight this sort of error.
Mark