How do I make a widget shows how much a show has made between the Onsale Date and its first preview?
My first thought would be to make an Indicator with 'Total Ticket Paid Amount' as a row, and then filter by 'Order Date', and set the date range to what you need it to be.This way, the widget would be pointed at how much revenue was generated, but only for orders before the date of the first preview.
Something like that, for instance, with an 'Indicator' Widget type.There are no doubt sleeker ways to do it, but that seems to fit what you need!
You could break it out by a number of other things (Order Date month, sales staff, mode of sale, etc.) if you wanted to.