I have a multi-dropdown form field for my Incident tickets. Contacts can choose one or multiple values to tell us which parts of the system are impacted by the incident.
I am trying to generate a graph that will give me a count of tickets for each value in this multi-dropdown, but I am unable to find the field in the ‘Group By’ on the widget builder.
I have experimented by adding more Multi Dropdown form fields and none of them appear as Group By options, but normal dropdown fields do.
Has anybody been able to create an Analytics chart that provides a count of tickets for each value in a Multi Dropdown form field, similar to how I can group tickets by ‘Tag’?
PS. On a related note, these multi dropdown fields are not appearing in my Ticket view, so I am unable to create a filtered view using them either.