My Director of Development needs our overall attendance by state for fiscal year 2023. The problem is we don't have our Geo_Area system table set up yet to pull our zip codes by state (yet, I'm hoping to get that fixed at the TLCC conference next week).
Does anyone else know of a way I might pull what she needs relatively easily without that?
Hi Chelsea,
If you've set up General Public Zip Question ID and optionally General Public Cust Type ID (Default Settings Entries for Tessitura Analytics), then Analytics may be associating your orders with the corresponding state of the zip code in the survey response. Try a Pivot widget in the Seats and Tickets data source using the Primary Address State on rows along with a value for either Total Ticket Count or Total Attended Count.