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?
Hi Chaya - the constituencies field in Analytics is a comma-delimited list of all constituencies a constituent has so the filter you have should be correct for finding anyone who has the FCM constituency! You would do the inverse of that to find folks who to not have the constituency. If you're looking to compare the two you can add that as a filtered value.
But is there a way to show them all together rather than separated? That's what I'm having trouble figuring out. I don't want all the different lines, just anyone with FCM included vs anyone without. Can I combine all of these lines into 1?
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,