I am trying to build a dashboard for the exec team and the data I can't seem to find is the count of seats that are currently in hold codes (holds), seats that are reserved but unpaid, and finally seats that are open for sale.
I also wonder if there is a "capacity" formula that may take into account those metrics above.
Thank you in advance for any help.
Best,
Michael
Dallas Symphony