Data Studio
5.1K members online now
5.1K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Separate into substrings and count numbers multiple in one dimension

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I have a question - maybe someone here might help me to figure out whats the best way to manage it with data studio. I have a field that could contain one ID or even an aggregation of IDs in the data source but I want to separate them. So if  the value is "1" it should count to "abc", if the value is "2" to "xyz" and so on.... same with the value "1,2,3". That works so far but if I manage the separation with a case statement the "1,2,3" does of course count for "abc" but not for "xyz" anymore. Furtheron "2,1,3" doesn't count for "abc".  I'm thankful for any help!