Thanks Rich. That works, but what I'm really trying to do is make it run for everything. For example, the Yes shows me that 72 people are currently online at a location; the No shows me that 27 people are not currently online at that location. I need to be able to not select a particular value in that drop-down and see that 99 people are in that location. One of my views is a simple pie chart showing who's online/offline. I did create a static list with three values Yes, No, All. The All label just gets a value of *, which works in this case because the particular field is always populated. This particular workaround won't cut it in the future if I need to do this for a field where NULL is allowed. I hope that makes sense.
... View more