How to report against multiple checkboxes?

kellykaufmann
Mega Guru

‎03-31-2015 06:53 AM

How can we create a report that pulls in multiple checkboxes from a form?


For example, in Demand and Project we have an 'IT Teams Impacted' section where we check boxes for each team impacted.Currently we can only run a report against one checkbox for counts that it's true or false.

An example of the report we would want: In the Demand table, a bar chart pulling all of the different (10) 'IT teams impacted' checkboxes, having each team be it's own bar, and we count the # of Demands in the 'Screening' state with each of those IT Teams Impacted checked. All seems to be easy except pulling multiple checkboxes.


Would we have to create 10 different reports (1 for each of the IT Teams Impacted), then find a way to pull these into 1 report?

Thank you so much for your help! And please forgive my non-techy terminology, as I'm not an Admin

Labels:
0 Helpfuls
  • 1,224 Views
1 REPLY 1

gyedwab
Mega Guru

‎03-31-2015 07:39 AM

Hello,



I think that with the out-of-the-box ServiceNow reporting solution, this will be difficult to accomplish. You can create 10 different reports, but the only way I know of pulling in together multiple data sets is through Custom Charts, but I don't know javascript well enough to say eactly how.



With Explore Analytics, you could pull together ten different reports into a single report and display them together.


0 Helpfuls