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.
Nathaniels right.
However i agree that it'd be great to filter orders by something like...
Order_dt < MIN (Perf_dt)
Marketing ask me that all the time (not in so many words). I might play around with custom ranges and see what i get
This worked perfectly! Thank you, Nathaniel and Heath! I appreciate it.