How do I truncate Glide list values for reporting? Urgent help needed

[Nadine Wighton]

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?

[gareth_oliver]

Hi @Nadine Wighton , 

Would a Report Range work?

Pro's:

- Report Range will group the GlideList values from your table

Con's:

- HeatMap report does not support Report Range.

I did a quick test on a table with a GlideList (data in sys_choice) & I was able to create a Report Range with the values from the table; a Bar & Pie chart showed the Report Range, however a HeatMap report did not.

Report Range:

Bar chart showing Range:

[Nadine Wighton]

Hi Gareth, thank you so much.  I will go try it out and revert back if I have no luck.

[PaulaaO]

Hi @gareth_oliver - may I please check if this behaviour is still valid? Report ranges cannot be applied to heatmaps? We're on Tokyo if that makes any difference. Thank you

[Nadine Wighton]

Kia ora Gareth, thank you for the suggestion.  While it has some merit, we think the issue appears is the way reporting interprets glide lists (i.e. comma separated values rather than the choice to report individual counts of a value across multiple records).  I need to be able to report glide list values independently and not as a cojoined list.  We have tried the 'range options' suggestion (thank you).  We could get some way there by only having a single count report but not when attempting a bar chart as it only reports the first instance of the record rather than all records it is referenced in.  Seems to still come down to a comma separated values list, rather than independent values.  Any other suggestions?