Trying to solve how to report by performance, current min and max price being offered by zone. What I've built using current base seat value ~mostly~ works, but I'm guessing, where it's wrong is when we have not actually sold a ticket at the price it's offered. Ideas?
Yes. The base unit of the Seats and Tickets cube is the seat, so you can figure out things like capacity even when not ticket has been sold, but I don't think there is any pricing information unless a sale is made. LIkewise, if a certain pricetype hasn't been used then it also won't appear.