I wonder if there is a way, for a particular series, if I could find out how many constituents went to more than one concert in the series (there are 13 individual concerts). The ideal report would have how many constituents went to one concert, two concerts, three, etc. But since that seems complicated, I could settle right now for a way of seeing how many people went to at least two of the concerts.
It's too bad in t-stats there doesn't seem to be a measure that indicates number of concerts attended...
Any help would be appreciated!
If this is a package and you are looking at those that did attend, this should work.
SELECT
COUNT(customer_no) AS customer_count ,
perf_count
FROM
( SELECT
osh.customer_no ,
COUNT(DISTINCT osh.perf_no) AS Perf_count
dbo.T_ORDER_SEAT_HIST AS osh
WHERE
osh.pkg_no = @pkg_no AND
event_code = 22
GROUP BY
osh.customer_no
) AS aaa
aaa.perf_count
Marty Jones
Director of Information Services
Omaha Performing Arts1200 Douglas Street
Omaha, Nebraska 68102
P 402.661.8469
Marty.Jones@omahaperformingarts.org
www.omahaperformingarts.org
For tickets, call Ticket Omaha at 402.345.0606
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Marty JonesSent: Tuesday, May 24, 2011 3:37 PMTo: Martin A. JonesSubject: RE: [Tessitura Marketing Forum] Constituents who went to more than one show in a series?
Define series. Is this a package? I am assuming yes. Also are you looking to see if they actually attended the performance or just purchased?
From: Tessitura Marketing Forum [mailto:forums-marketing@tessituranetwork.com] On Behalf Of Gabriel RiveraSent: Tuesday, May 24, 2011 3:12 PMTo: Martin A. JonesSubject: [Tessitura Marketing Forum] Constituents who went to more than one show in a series?
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Marketing Forum. You may reply to this message to post to the Marketing 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!