Tracking seat holds in Analytics

Anh Le $organization over 5 years ago

Hi everyone,

I’m hoping to find some advice on how to go about building an Analytics chart that will give me a stacked bar chart showing paid, reserved unpaid, held, and available seats in one glance. I built the paid and reserved unpaid portions no problem, but cannot figure out a workaround to count held seats in the same chart. I’ve put a screenshot of the chart in progress below in case that helps demystify what I’m trying to do.

If anyone has any tips or advice, I’d be very grateful!

Timeline

Description automatically generated

Chris Wallingford $organization over 5 years ago

Hi Anh,

Have a look at Filtered Values. Using them with a combination of Seat Hold Code and Seat Sold Flag would allow you to limit to just Seat Sold Flag = N and Seat Hold Code = (none) for Available or <> (none) for Held.

(SUM([Seat Current Base Amount]), [Seat Sold Flag], [Seat Hold Code])

Alternatively, the Seat Status field might be slightly easier, filtered to Held or to Available.

(SUM([Seat Current Base Amount]), [Seat Status])
Cancel
Vote Up +1 Vote Down

Sign in to reply

Cancel
Anh Le $organization over 5 years ago

Thank you, Chris! This is super helpful.

Anh Le | Director of Marketing & PR

Opera Theatre of Saint Louis | ExperienceOpera.org

ale@opera-stl.org | (314) 963-4294

.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel