I have been asked to find the top 100 ticket buyers in our system. (Based totally on the number of ticket purchased.) But I'm not sure what is the best way to go about finding this information. I do have T-Stats but I'm stumped on the recipe. Any ideas?
Thanks,
Elizabeth Carlock
The difficulty with using T-stats for something like this is that it looks at ranges, but not really individual constituents. As much as I love T-stats, I think you are better off with the sql from Tessitura.
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Wayne EvansSent: Friday, July 06, 2012 9:43 AMTo: Nicole KeatingSubject: Re: [Tessitura Ticketing Forum] Top 100 Ticket Buyers
I don't have t-stats, but a general approximation can be found by running sql:
select top 100 o.customer_no, COUNT(o.customer_no) as tickettotal
from dbo.T_SUB_LINEITEM s
inner join T_ORDER o on s.order_no = o.order_no
group by o.customer_no
order by tickettotal desc
This just counts the subline items, which also include refunds comps etc..., but as its just a top 100, the answer will be approximately correct
From: Elizabeth Carlock <bounce-elizabethcarlock8778@tessituranetwork.com>Sent: 7/5/2012 2:33:25 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!