I have a feeling this is a filtered values question and I should just rewatch the webinars, but I thought I'd ask here first. I'm trying to setup a widget that will only show people who have purchased 10 or more tickets to a single perf (a special exhibition). I've managed to use conditional formatting to make those people show up in a different color, but really I'd just like to exclude those with fewer than 10 tickets. I'm attaching my dashboard with just the one widget.
Thanks!
Anne
NotreDame10+tickets.dash
I think you can just do it by filtering off of the 'Sum(ticket count)' formula you've set up:
It will inherit the conditional formatting, as well.
I knew I was making it harder than it needed to be! thank you! That did it.
You're welcome! Glad I could help.
It's worth noting that this filter will work in light of the rows. If you have 'Constituents' or 'Order ID' as the final row, the ticket count will be viewed in light of those Constituents and Order IDs. If you just have Perf Date, it'll say "Does this perf date have more than 10 tickets?", and include it if it does. In other words, it's asking 'does this constituent, in this perf date, in this prod season have more than 10 tickets?' If you tinker with the rows, it'll change the results.
If you want to get more granular, you could up the formula to bucket for 'order ID where tickets > 10', and filter the widget by that.