Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have list of groups in my table which is having common sub-strings. I want to create graphs based on that sub-strings.
Example:
A_JIR_DEV
B_JIR_RED
A_CON_DEV
B_CON_RED
In my dimension, I am trying like "=if(group_name like '%_JIR_%' ,group_name)".
Thanks,
Arpit
for this result
the script is
load
field,
SubField(field, '_', 2) as substr1,
SubField(field, '_', 3) as substr2
inline [
field
A_JIR_DEV
B_JIR_RED
A_CON_DEV
B_CON_RED
];
if you don't want to modify the script, you can use subfield in a calculated dimension too