How to plot checkbox group data when multiple boxes are checked

[Justin_Artis]

I have a checkbox group within a form that allows users to select one or more options. The form is then automatically plotted in a pie chart. When a user selects multiple checkboxes, confluence plots the entry as a new data point (chart 1 below). I would like the chart to count only the boxes checked (chart 2 below).

For example, if a user selects A and B from the checkbox group, I would like 1 count for A and 1 count for B, instead of 1 count for A; B. 

[Andrey Khaneev _StiltSoft_]

Hello Justin,

Do you use some macro as a form or a table?

[Justin_Artis]

Yes, I used the "ConfiForms Form Field Definition" macro to store the data in a form. I then used a pivot table to count the responses and created a chart from that table which yields the results above. 

[Katerina Kovriga _Stiltsoft_]

Hi @Justin_Artis ,

Can you please give us an example of your table after ConfiForms macro? What columns and rows do you have?

As usual, the Table Filter and Charts for Confluence app works well with ConfiForms, we'll try to reproduce your case and give you some tips.

[Katerina Kovriga _Stiltsoft_]

@Justin_Artis , we assume that you have smth like that:

When you use the Pivot from Table macro with standard settings you count the number of variants (combinations):

But if you go to the Options tab and set the Cell value delimiter, you will count letters:

Now you can build your chart - it will look as the Chart 2 from your example.

[Justin_Artis]

Yes! That worked perfectly, thanks for your help.