Are glide lists groupable in reporting

[mforward]

I created a list report and would like to group by a glide list field, however that particular field is not available in the Group by drop down list. Are glide lists not able to be made groupable for reporting because of its data type?

[Tom Brown]

I acknowledge that this is a very old post, but we attempted this with Platform Analytics to attempt to get a group by like this, and while the field would show up in the group by list, the visualization would reset it back to the first entry in the list every time we hit 'Apply'.  Thought we might save someone else the trouble.

[CapaJ]

glide_list fields do not support grouping or sorting (as you'll see in Core UI lists and elsewhere). Anywhere in the UI that *lets* you try it probably shouldn't. While you're not prevented from taking a URL with, say, GROUPBYstate and manually changing it to GROUPBYwatch_list, results may be unexpected.

One primary reason for this is because "Abel Tuter,Beth Anglin" would be expected by many humans to be in the same grouping as "Beth Anglin,Abel Tuter", but they won't be.

While you can override default behavior, you could add the can_group=true Dictionary attribute to a glide_list field. But again, results may be unexpected (and potentially performance-impacting) so that's done at one's own risk

[Tom Brown]

I understand the 'why' and limitations.  We had a user insisting we try, so we were going through some convolutions to see how it looked.  I don't think they understood how unreliable it really would be.  I found it interesting that PA show the field, but would kick it out even it was allowed using the can_group=true property.