So I finally got my zip code dashboard built the way I wanted it (took freakin long enough). I added a fun area map to show the actual states where people were coming from. I though having CA when our org is in CT was a little weird, so I did some investigating.
There were 27 tickets sold under the 99999 zip code (which was our workaround in our old system and in v15/v16 for the required complete postal record). I knew those had to be constituent records because my front desk kids would never put that in as a survey question.
Anyway, I was right and that they were attached to constituents. I added the Constituent Display name as a row to find which exact ones. However, this is where it gets weird; in the Total Ticket Count Column, there are now entire rows with 0 in that column. My dashboard is set up so that if it is 0, it should not show up at all.
I also checked the Mode of Sale and all of these were done as Walk-Up Sales, meaning one of my front desk associates had to type each name into Constituent Search in QuickSale to process it. And if its GA, our GA performances are set to auto-attend. And I went back and looked at all of these records and their Order history. All the 0 tickets are from the same event, but all of them got marked as Attended. So those 0 rows should have a real number in them and they don't.
Can someone explain what could have happened before I open a support ticket?
I'm curious -- have you tried adding in a column for Ticket Count (in addition to attended count)? I'm wondering if the tickets are showing up there.
Just tried it and the numbers match in both Attended Count and Ticket Count. It's all still pulling 0.