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. 😞

1 REPLY 1

kbukg
Tera Contributor

Attempting to bump this for attention.