Hello everyone,
We are trying to migrate our old reports out of TStats and into Analytics. One of the numbers we need is a total count of all showings of each show in our Omni Theater by month. We have one Omni performance for each show every day, and we enable or disable zone times according to the showtimes for that day. In TStats, we used to use the Tickets Cube, which had a measure called "Num Perfs." This allowed us to get a number of showings by zone time for each show that month. We are trying to rebuild this in Analytics, and are unable to find anything quite like "Num Perfs" as a data type or a function. We have found "Count Performances Past Year," but the resulting numbers are way too high. We suspect that it is counting every instance of the performance and all zones, whether they are enabled or disabled. What we're really trying to do is count the number of enabled zones across all performances for a each show by month. Has anyone else run into this particular challenge and have any insights?
Thanks,
Marisa
CRM System Services Coordinator
Museum of Science, Boston