I've created in intake form where one question is a multiple select field that has three options. Any combination of those three options can be selected. Once the form is submitted, the results are sent to a single field.
I am trying to create a report using this field but in the report results, it is showing the results as a single data point rather than each one individually.
Example: If the field options on the intake form are Team 1, Team 2, and Team 3 and the person submitting the form selects all three, it shows as Team1, Team 2, Team 3 in the field.
In the report, let's say I need to show in a pie chart all projects by teams. For this example, it is returning the result for this project would be one project for 'Team1, Team 2, Team 3'.
The result that I am hoping for is the project to show each team to be assigned to the project individually in the pie chart.
Is this possible? If so, how can I accomplish this? If not, is there a different way (other than making each selection its own field) that I can set the form up to accomplish this?
Thank you!
