I have list of groups in my table which is having common sub-strings. I want to create graphs based on that sub-strings.
In my dimension, I am trying like "=if(group_name like '%_JIR_%' ,group_name)".
for this result
the script is
SubField(field, '_', 2) as substr1,
SubField(field, '_', 3) as substr2
if you don't want to modify the script, you can use subfield in a calculated dimension too
Retrieving data ...