What would prevent a field from showing as a Group By on a report?

[e_wilber]

I'm doing a very basic report for the Incident table on a custom field u_department that pulls from the Department table.

On my list report under Group By, I cannot select Department. It's there as an available column in the report but it doesn't let me set the report to group by it. I know reports can group on reference fields (such as Assignment Group) so what might be causing this field to not display in the condition builder?

[Alikutty A]

Hi,

You cannot group by on a field which is of List Type.

Thanks

PS: Hit like, Helpful or Correct depending on the impact of the response

[e_wilber]

Sorry, I am not sure what you mean. The field is a reference field to the Departments table, it's not a list field.

[Michael Fry1]

From a list view of your Incidents, can you right-click on Department and select Bar Chart. Does it group by Department?

[e_wilber]

It's strange you asked that because I just tried that a couple of minutes ago and to my surprise, I cannot group by that column from the incident list.

In my personal instance I added a new custom reference field and linked it back to cmn_department. The report works just fine. It's just this once instance that it's acting weird. I don't suppose there's a setting someone that could be set to not allow a specific column to be grouped by?

Since it's a user created field, maybe it's just corrupt and needs to be rebuilt?