Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
May be like this
Dimension: Incidents
Expression: Count({<Incidents={'ACK,SUSP,OP'}>}Incidents)
Regards,
Andrey
use 2 expression in chart
Raised
Count({<Incidents={'ACK,SUSP,OP'}>}Incidents)
Resolved
Count({<Incidents={'RE'}>}Incidents)
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)
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