Hello friends,
A few weeks ago, I asked about this at an analytic Coffee! session, but I need to ask again because I don't quite understand what to do with the answers that you all gave me...
My goal is to count performances in a FISCAL YEAR, not the past calendar year from today.
I found this foreign language in the notes from that specific analytic Coffee! session:
MIN( [Calendar Year] * 10000 + [Calendar Month] * 100 + [Calendar Day of Month] )
IF ( MAX( [Total Calendar Year]*10000 + [Total Calendar Month]*100 + [Total Calendar Day Of Month] ) = 20211126
( [Total Ticket Paid Amount] ) , NULL )
but I sure don't know what to do with it!
My goal is to count performances from 9//1/22 through 6/30/23. I'd also like to be able to exclude specific seasons and/or price types if you can help with that...
Thanks for your help!
Since you know the date range (9/1/22 - 6/30/23), and you know the seasons / Price Types you want to exclude, couldn't you stack those filters on the dashboard or widget?
Your value would be [# unique performances], and you'd filter for [Performance Date] = 9/1/22 through 6/30/23, the [Season] or [Production Season] would remove the ones you don't want, and the [Price Type] filter would do the same.
Your Rows could be anything, really, but I'd default to 'Performance Date' -> 'Calendar Year', and sum up the totals for each year.