count of projects by state but some projects have multiple states
Hi,
I'm trying to create a chart that has states for the dimension, and count of projects by state. However, some projects are in multiple states, and all the states are in the same field for those projects, separated by a semicolon.
So if I use state as the dimension, you will have the 50 states, but also a bar for NY;CT, a bar for NY;CT;VA, and any other project that have multiple states.
Any way to parse this out in a calculated dimension? Or would it have to be done in the script?
