Grouping values

[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. I tried doing the group feature with looker and I also created a field using the contain_text function however, if for example there is an event "Valentine, Christmas", it will only be counted in the Christmas bar but not in the Valentine bar. Is there a way to have them counted in both ? 

Hope I was clear!

[lauratilton]

Two options:

• restructure your data so that you have multiple records when there are multiple responses. That's really the only way to count something twice!
• set up a separate chart for each option (ie, a bar chart with only one bar for Christmas that just counts entries that contain Christmas, and then a separate bar chart with only one bar with the Valentine entries.) You'd have to set them all to the same scale so that they will be comparable.

[cvievard]

Thank you!