Hello Friends! I am trying to create a widget for Admissions that shows last week's admission count by day of the week (shown below) with a line on the right axis to show the fiscal year to date average for each day. I am really stumped on how to obtain the average (which would be the YTD count of Admission for a day of the week / the count of that day of the week in the year). Anyone have any insight? I thought this would be a good way to show how our weekly attendance compares to our YTD average by day.
Thanks in advance!
Hi Sue,
Have a look at the Tessitura "Attendance" pre-built dashboard in the Seats and Tickets folder. The bottom left widget, Daily Average Attendance (this and last 2 years). Here's the help page on that dashboard: Tessitura v15.1 Help System - Attendance Dashboard (tessituranetwork.com).
To enhance it to your FYTD needs, use Filtered Values to limit each of those values to just the current FY. For example:
( [Total Attended Count] , [Attended Date Fiscal Current Year Offset = 0] ) / ( [# of unique Days in Attended Date] , [Attended Date Fiscal Current Year Offset = 0] )
Once you have that value created, use the Options menu on the value to set it to a line chart on a secondary axis.
Chris, this is brilliant and it worked for me! Thank you for the guidance on this high-level Analytics trick! Would it be OK for me to email you my dashboard and have you take a look at this widget to ensure I've got the parameters correct before I publish it out? Here is what my new widget is looking like...