I am having a (simple?) problem which I can’t seem to figure out.
I am trying to build a simple field service app that allows a user to display a list of states where there are current jobs (which will be displayed on the map) as well as the count of total number of jobs per state. I cannot seem to be able to return the unique value for the states as well as the total count of jobs. I tried creating a separate table for states and playing around with now luck .