Hi Everyone,
I'm trying to figure out how I can look at contributions from one constituency vs everyone else. The issue I'm running into is that the constituency "FCM" is generally not the only one on these accounts. So if I use the straight "constituency" filter in dashboards I get a string of a bunch of different constituencies. I want to combine any constituent that has FCM as a constituency whether it's the only one they have or they have more. I think this is probably possible using an advanced query, but that is beyond my capacity. Has anyone set something up similar to this? Have a query I can borrow?
Basically I want to combine all of these to be one value, the other value being anyone WITHOUT FCM constituency
Hello Chaya,
The Constituencies field (as with the Lists field) is intended for filtering rather than display within a widget. To filter a value, widget or dashboard to just constituents who do not have FMC, change that Containing ,FCM, to Doesn't Contain ,FCM,.
Containing ,FCM,
Doesn't Contain ,FCM,