Find all Customers with one order per season?

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

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?

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!

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

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?

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!