Issue with list field (multi-select) reporting

[Radha K]

Hello Everyone, 

I am trying to create a report on one of the table and am trying to group by 'list field'. This option is not available, since the list field(multi-select) might contain more than one option. However, when I click the additional group by, I see the list field to select and am able to select the Work Sub-Category in Additional group by

I cannot display the Pie chart with default Work Sub-Category. I have to go to report and change it every time from option below the Pie.

Can someone please help me make it default to Work-SubCategory? Thank you.

[sachin_namjoshi]

Group by works for fields which holds single value.

It won't work by list since it contains multiple comma seprated sys_id.

In your case, you should create interactive filters for your report and use this filter in dashboard.

This will filter out data based on interactive filters.

Regards,

Sachin

[Tushar Hirpurk1]

Hi Radha,

              Try to select group by as "Active" and additional group by as "Work Subcategory".

hope this will help.

Regards,

Tushar

[Adam Stout · Accepted solution]

Give this article a read on how to report on lists: https://community.servicenow.com/community?id=community_blog&sys_id=36ee942edb1304501cd8a345ca961974

[Radha K]

Thank you Adam. This is exactly what I am looking for. I appreciate your response.