I'm putting together a dashboard to track an event that happens every Thursday evening. However, we need widgets to track the 1st, 2nd, 3rd, and 4th Thursday separately. The problem comes in with the Calendar Week of Month filter. It starts with Week 0 and ends with Week 5. The first Thursday during some months will be Week 0 in Tessitura and other weeks will be Week 1. I'm not sure how to handle this shift, because all of the subsequent widgets will also need to shift down a week in those cases.
Here's a screenshot of the current setup for the 1st Thursday:
Is there an easy way to set this up so we don't have to adjust it each month?
Hi Mark,
See if this gets you there: https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_shared_reports-9/33682/analytics--attendance-date-by-recurrence-pattern-e-g-every-third-sunday-of-the-month/87455#87455
I think the last image has an indicator like you're wanting, and there's a sample dash attached.
This looks promising, thanks for the link. I'll give it a go.
Let me know if you get stuck.
Thanks for the assist, Chris. This looks to work well for us. I had some issues in the beginning but I realized the formula was using Create Date, so I just went in and changed it to Performance Date. I should be able to set this up once and hopefully not have to worry about it again. Thanks again!