Reports: Bar Chart on Multiple Check Boxes (True|False Variables)?

[Garth_AZ]

I have been asked to put a bar chart (report) on a dashboard where each bar represents the count of how many times a check box has been checked on a requested item.

For example, requested item "Example" has a series of 26 check boxes labeled A - Z and asks the submitter to select one or more of those letters. They want me to query all submitted "Example" records and display a bar chart showing the count of each letter (how many times A was selected, how many Bs, how many Cs, how many Ds, etc).

Is it even possible to create a bar chart where each bar represents a separate variable? I don't know how to do that.

Thanks 

[Robert H]

Hello @Garth_AZ ,

Yes, you need to create your report on the Options [sc_item_option] table. This is where the variable values of submitted requests are stored.

Then you need to filter for all checkbox variables that belong to the Catalog Item you are interested in and were checked by the requester (Value = true). Finally group the report by the Question (=variable).

Regards,

Robert

[Garth_AZ]

Thanks Robert, that would be helpful if I asked the question correctly.

It turns out they are not a variable's choices, but rather they are fields on a custom table.

My problem is I cannot Group by multiple fields. I can select all the fields in the Additional group by, but I have to select a single Group by first, so that doesn't really do anything.

I'm starting to think this might be a job for Performance Analytics to dump the results in a data source... 🤔