Thanks jarvis. I probably can’t use the first query because then i would have specify each state in the query and we will be constantly adding new company locations, so i kind of want it to work a bit organically.
The second one, i am going to try that out now.