Hi there!
I'm curious if anyone has any clever ideas for this. I track scan rates for our performances in a few different widgets (most of which are simple Attended Count vs. Ticket Count calculations). We had one show last weekend where the scanners were down for a bit after the house opened, so the ushers did not scan about 2/3 of the house; unfortunately, they did not keep ticket stubs for us to manually enter in the Record Attendance utility later either. They did, however, keep a headcount, so we do know how many people attended. I'm wondering if there's a way I can hard code in the attendance count for this one performance, while still using Attended Count for the other performances in the run. I'd like to avoid just randomly "scanning" in the correct number of tickets for the performance because I also think it is valuable to know which patrons were and were not actually in the theater that night. I appreciate any thoughts or creative solutions you might have!
Thanks!
Lauren
In Analytics, you could use a CASE statement. Let's assume your one date with the issue had a unique attendance of 468 and it should've been 890. Your case statement could be something like CASE WHEN [Total Attended Count] = 468 THEN 890 ELSE [Total Attended Count] END. I'm assuming you are looking at a pivot table.