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 ?
@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
Did you find a solution to your question? Mark the solution as accepted ✅ and if you found it useful, press the like button!
