Hello!
I'm hoping that this is a really easy fix and I'm just missing something obvious.
I'm trying to get an indicator widget to show the number of constituents who bought tickets for the 2018, 2019, 2021 OR 2022 seasons, with a ticket paid amount >= $200. I've started with a pivot table, and when I export it to CSV and take the constituent ID's and remove dupes, I get 1,071. When I remove columns and other values in the pivot table and just look for # of unique Constituent ID, I also get 1,071--so far, so good. Then, when I take the pivot table, duplicate it, and turn it into an indicator, it becomes 2,080 every time. I'm certain that it's counting the constituent for every season they bought tickets, but I'm not sure how I can get it to stop. I can get it to work in a similar widget for contributions over those same fiscal years, but not here.
I feel certain it's something glaringly obvious and I've probably even encountered it before. Let me know if you need me to share more information to help troubleshoot.
Thanks!
Michael Dorsey
Indicator widgets only have one value field. Have you confirmed that what is being pulled over from the pivot is the correct value? You might need to adjust your filters too.