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
Brainstorming, would it be easier to do this by lists? I have a dynamic list for all FCMs. Could I use that to do in the list vs not in the list?