• Replies 2 replies
  • Subscribers 331 subscribers
  • Views 137 views
  • Users 0 members are here
Related

Tracking seat holds in Analytics

Anh Le
$organization
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
Parents
  • $organization

    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])

Reply
  • $organization

    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])

Children
No Data