Hi,

I have a multi choice field in Service desk that is imported into Analytics Plus. 

What I'm finding is - if i do a report on this field it will list them with all options that have been selected - so for example -

I select for request1 - 

Option 1

Option 3

Option 5

I select for request2

Option 1

I select for request3 -

Option 1

Option 3

I select for request 4 -

Option 5

How can i run some kind of report that totals them up. What I'm finding is if I do a report on this field.. it will list them as multiple options. I'm after some kind of report to show total amount of times each option was selected - regardless of if other options were also selected.

So for example - 

Requests where option 1 was selected = 3

Requests where option 2 was selected = 0

Requests where option 3 was selected = 2

So totalling up each option regardless of if more were chosen.

thanks