After much back and forth with Tessitura -- and I think we still don't quite understand each other -- I'm trying to put together a dashboard for yesterday's museum attendance to take the place of the Attendance by Performance report. My widget for total number of attended seems right, and my break down by zones looks okay. But there are two things I'm struggling with -- one of the things included on our daily report is how many tickets were purchased vs. attended. Our admission is free, so we get a lot of no-shows and it is important to see just how many. When I try to pull in any kind of metric on total tickets sold, I'm getting the same number as the attended count. Is there no way to pull in sold, but unattended tickets into Analytics? I'm also trying to set up a widget that includes constituent info and then sort it by zone, but if I use the same zone ranking that I use in my widget that doesn't have constituent info, it doesn't work. Is there anyway to get the zones in order while including constituent info? I'm attaching my dashboard. Thanks for any suggestions!
Anne
Yesterday'sMuseumAttendance.dash
I suspect that you are using the Attended date as a filter for the Tickets Sold instead of Performance date. I've been there and done that before.
You could also try a filtered value for the ticket count.
I realized that as you were typing! But after changing it, now I'm getting January 1, 1900 displaying, as well as yesterday's numbers. (don't ask me where those numbers are coming from). And I'm still not getting any difference in total tickets vs. attended.
Try moving the filter to the formula level for both measures and turning off the widget Attended date filter.
... and then add both dimensions to your pivot table.
Thanks, Neil! I think I have it working. I had to include a widget filter for the date or it was giving me 0 tickets attended, even with the filter in the formula but it looks the same as my Attendance by Performance report. (Which Tessitura is telling me shouldn't match -- that the report has inflated numbers and that Analytics is more accurate, but whatever. As long as it is working!)