I have a glide list on HRSD core table. It contains around 70 values. I need to create Heatmap reporting whereby each attribute is counted rather than as a string of all glide values on each individual case. I need to be able to theme the count a particular variable value is mentioned independently over all cases to identify which particular question is asked.
As seen below, as the glide record is concatenating for reporting purposes, Theme A is also showing in other themes as it's mentioned on the same individual case records. I need to find a way to split these out so we can clearly see the number of times a particular theme/subject/question has been mentioned.
If Glide lists cannot be truncated for reporting purposes (I sincerely hope they can somehow), can anyone else suggest another approach that might get the outcome I'm looking for?
