Chart (diagram) for multiple answer field

Question

Dear people,

Multiple answers are possible in my query.
People can choose from answer options 1, 2 and 3.
Entries such as “1,2”, “1,2,3” or just “1” are logically included in the answer field (see picture).

I would like to display the results in a chart (diagram) (see picture).

However, I want to have bars ONLY for 1,2 and 3 (but not for "1,2" or "1,2,3"), but I want e.g. that the result "1,2" increases the number for 1 and for 2. Is this possible in Experience Builder ?
I've tried a lot there but haven't found a solution yet. 😕
Maybe someone can give me a hint?

KaiBehncke · Accepted Answer

Ok, I have found a solution. I have done that via ArcGIS Survey 123 Collet.

I have a field for multiple answers and in the form.xlsx file I have implemented some hidden fields for the responses "1", "3" and "3". If one checks in the multiple-answer-field "1" and 3" this is automatically written to the specific hidden fields (with integer-values (!) (important).

With that structure in experience builder it`s possible to get what I want: