Hi all,
I'm trying to create a breakdown based on a text based field on our location table called u_region. I feel like i've tried everything from scripts to mapping and am not getting the expected results. I have an indicator of "number of open incident tasks" where i need to breakdown that indicator by the different regions assigned to each location. Anyway i could get help on a general direction i should go?
Things i've tried:
1. your standard intro breakdown methods
2. a script to pull the region from the cmn_location table and return it
3. a script to pull the first two characters of our location.name (that's our region) and return it
Either i get
1. The regions but no results
2. No elements to display
Thanks in advance!
