Chart dimension

[QSense]

Hello ,

İn chart , I want to add calculated dimension that get A field's value but value's description equals to 'Kritk and kritik Ariza'

My fields

Vardiyarap_rootcause                Description

x                                                           Kritik

N                                                            Nothing

y                                                            Kritik-Ariza

z

I wanna show only x and y values in dimension

[sivarajs]

Try like

if(wildmatch(Description,'*Kritik*','*Kritik-Ariza*'),Vardiyarap_rootcause)

[jagan]

Hi,

Try this way

If(Match(Description,'Kritik','Kritik-Ariza'),Vardiyarap_rootcause)

Hope this helps you.

Regards,

Jagan.

[#4]

Hi

Use below exp in calculated dimension

if(Vardiyarap_rootcause =x or Vardiyarap_rootcause =y, Description,null())

then enable the supress when value is null