Group By List of Text

[daniel.petrin]

Hi,

I have to do a chart, that should count the values.
The problem is that the values are “List of Text”, and i cant group by in bubble a list of text.

For example:

This are the data that i need to count.

In this case, i should group like this:
Verde: 3
Azul: 1
Roxo: 1
Vermelho: 1

And after, use in some chart.

But i cant group!

Anyone has some idea?

[ksplinter007]

you would have to do a search for line items that contain “text” count

[ksplinter007]

so youd have a repeating group of the things that have the colors in the list

then youd have a repeating group of colors that searches for the things whos color list contains that color