Create categories of values in a bar chart

[cvievard]

Hello

I am currently building a bar chart that counts the amount of events organized per theme. However, sometimes an event has two themes. So, if for example there is an event "Valentine, Christmas", I would like for it to be counted in the Christmas bar and the Valentine bar. Is there a way to have them counted in both ? 

Hope I was clear!

[MatheusC]

@cvievard 
In your example, the values "Valentine, Christmas" belong to the same field?

Do you want a separate view of these values, as unique fields?

If this is your case, work with the subfield function. It will create a record for each theme in your list that is separated by a comma, as in your example:

subfield(theme, ', ')

You can also use this same function in your script:

subfield(theme, ', ') as uniqueFields


- Matheus