if condition

[mshailaja]

Hi

i have table called  status  in which Incidents status wil bee updated as

RE,CL,OP,ACK,SUSP

The user wants only ACK,SUSP,OP as Raised Incidents

and RE as Resolved Incidents.

I have to  show the incidents  for the particular group in the Graph as Raised Incidents and resolved Incidents

Can anyone help me to write the if condition in script ,  so that i can get the graph like below

[ahaahaaha]

Hi,

May be like this

Dimension: Incidents

Expression: Count({<Incidents={'ACK,SUSP,OP'}>}Incidents)

Regards,

Andrey

[dsharmaqv]

use 2 expression  in chart

Raised

Count({<Incidents={'ACK,SUSP,OP'}>}Incidents)

Resolved

Count({<Incidents={'RE'}>}Incidents)

[avinashelite]

You could create new field in the script like this

if( status='ACK' or status='SUSP' or status='OP','Raised Incidents','Resolved Incidents') as New_Status

add the New status as the dimension

and expression

Count(Incidents)

[rahulpawarb]

Hello Sailaja,

Please use below sample expressions:

     If(Match(Status, 'ACK', 'SUSP', 'OP') > 0, 1, 0) AS Received,
     If(Status='RE', 1, 0) AS Resolved

Refer attached sample application.

Regards!
Rahul