I recently updated a custom form field from radio buttons to check boxes and now the chart is not functioning in the report. It is showing "no value." Is there a way to get the chart to work with the new custom form field that is has check boxes?
Multi-select fields like checkbox fields don’t natively work in charts. What I’ve done in the past as a workaround is creating a calculated text field in the same custom form that automatically captures and concats the selected options in your checkbox field. Then you’d use that calculated field in your report instead of the ‘actual’ checkbox fields. This works because WF sees the calc field data as a single unit/answer to group by.
A big downside to this to point out: if you have many checkbox field options this can get tricky. Since every answer combination is seen as a grouping, you will have answers show in multiple groupings. Example:
If you have checkbox options for project type - if you have project as email and social, and another project as social and website asset, social will show in both groupings in your report. So if you have a lot of options and many multi-answer projects, every scenario present will show as a grouping/bar in a chart.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.