Reporting on Multi-Select Variables

kbukg
Tera Contributor

Hello, I'm hoping someone can help. We are launching a new catalog item where, at the time the request is closed, the fulfiller notes certain data points. In this instance, they will fill out a multi-select field that notes what specific options were agreed to. 

 

However, when I go to create a report, it's not accurately reporting how many times each Option was chosen, because on requests where multiple options were selected, it's showing that as one variable. If I change the filter to say "Which non-standard terms/additions were agreed to? contains Option 1, it says no data to display. See the attachment labeled Help.jpg.

 

What I want is for it to display like the attachment labeled Desired State.jpg.

 

Please tell me there's an easy way to fix this, because I don't want to go back to the devs over it. 😞

2 REPLIES 2

kbukg
Tera Contributor

Attempting to bump this for attention. 

Radha K
Kilo Guru

FYI - refer to this article

 

https://www.servicenow.com/community/performance-analytics-blog/reporting-on-lists-part-3-3-on-conqu...


RK
If my response is helpful, please select Helpful. If my response answers your question, please select Accept as Solution.