Chart on a list

[dennis35]

Hello Community,

I have a table with a enumlist field that could contain for example

1. A

2. A, B

3. B, D

4. A, C

What I need is to create a chart on single values of that field.

So it should me show that record A has 3 occurrence, record B has 2 occurrence, record C has 1 occurrence and record D has 1 occurrence.

Is it possible ?

Thanks

[WillowMobileSys · Accepted solution]

No, not with your current setup.  You would want to switch to Parent/Child setup, where your EnumList values are each represented as a single row in the Child table.  The table would be be similar to:

ID	Parent	Type	Value
Key 1	Parent Key	1	A
Key 2	Parent Key	2	A
Key 3	Parent Key	2	B
Key 4	Parent Key	3	B
Key 5	Parent Key	3	D
Key 6	Parent Key	4	A
Key 7	Parent Key	4	C

You can then use this child table in a Histogram type chart.

I hope this helps!