Using Like function in Dimension

[#1]

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

[maxgro]

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