Separate into substrings and count numbers multiple in one dimension[ Edited ]
June 2017 - last edited June 2017
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!