Hello fellow Tessiturians!
I need to find everyone who ordered one specific show in the season but no other shows. I'm stumbling through the code on this one. The Number of Unique Performances will find multiple orders and I want to find people who have just one order with one specific show. So there would be no other shows on the order and there would be no other orders in the season.
Any help?
How about using an Extraction and having the first segment be for the season in question and Number of Unique Performances > 1 and set it as a suppression segment. Then the second segment just show you want. Anyone who purchased more than one show will be assigned to the first segment and unavailable for the show segment, leaving you just the people who bought that show.
Kevin Sheehan
Documentation & Learning Resources Specialist
Tessitura Network
1 888 643 5778 ext 329 Office
ksheehan@tessituranetwork.com
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gloria Ormsby Sent: Tuesday, September 14, 2010 4:02 PM To: Kevin Sheehan Subject: [Tessitura Technical Forum] Find all Customers with one order per season?
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!
Brilliant! Works great. Thanks Kevin!
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Kevin Sheehan Sent: Tuesday, September 14, 2010 4:27 PM To: Gloria Ormsby Subject: RE: [Tessitura Technical Forum] Find all Customers with one order per season?