Incorrect chart value for multi-checkbox field

Marketing & Content Hub Reporting & Analytics
1

Hi HubSpot,

I am creating a report (Custom Report Builder) to show the breakdown of all webinar form registrations. As we are using the same form across different webinars, I used the multi-checkbox field (Registered webinar) in my X-axis & count of contacts in y-axis filtered event timestamp to ‘this year’.

Referring to image below, what i noticed was when I wanted to only show specific webinars in Vertical Bar (include data if match all the filter below), the value (20) (count of contact for specific webinar) isnt the same when compared with form submissions (should be 25). Because i deselected certain webinars, I noticed this affected the value. For example, if contact Z has webinar A, B & C, but filter only wants to see webinar A & B, contact Z will not be included in the chart. Ideally what i want is anyone who meets the requirement (eg: webinar A &B) should be included in chart. (**btw the chart mentions count of website activities but it is actually count of contact. i couldnt change it.)

Could you share what im doing incorrectly & how I can view certain webinar for X-Axis without affecting data?

Thanks

DGanasan_2-1694572016274.png
DGanasan_2-1694572016274.png1664×526 97.6 KB

DGanasan_3-1694572139715.png
DGanasan_3-1694572139715.png980×308 60.7 KB

DGanasan_4-1694572422564.png
DGanasan_4-1694572422564.png397×718 45.8 KB

2

Hello @DGanasan
reason why the chart value is incorrect is because the way the Custom Report Builder handles multiple checkbox fields. When you deselect certain webinars in the filter, the report is only counting the contacts that have those specific webinars selected. So, in your example, contact Z would not be included in the chart because they have webinar C selected, even though they also have webinars A and B selected.