if condition

[mshailaja]

Hi ,

I have status field as Acknowledged, transfered, resolved, closed and suspended

i  am keeping filter status.

in the set analysis i have to show in the graph as

Incidents received and resolved

Formula

Received=count({<status={'Acknowledged','transfered','suspended'}>},inno)

resolved=count({<status={'resolved','closed'}>},inno)

while i am filtering with the status field the chart is not filetring as i have wriiten the calculation of status in set analysis.

i have to write in script level, can ayone please help

the user  requirement is he wants to filter the status, with that he wants to see the chart to be filetred. HOw?

please help

[sunny_talwar]

Try these

Count({<status *= {'Acknowledged','transfered','suspended'}>} inno)

Count({<status *= {'resolved','closed'}>} inno)

Implicit Set Operators

[mshailaja]

Hi sunny

you didnt get my point.

i am using filter status  in the dashboard

since i am using set analysis calculation , i cannot abl to filter  with status ..

i want to do in script level

now i am filtering in the   status , i cannot able to filter as i have wrote set analysis in the chart

please help

[sunny_talwar]

Why can't you filter? How does doing it in the script would help? I am not sure I understand

[mshailaja]

i am hardcoding in seta anlysis, thay why i cannot filter status, i want that hardcoing to be used as fileds in script level..

Formulas are

Received=count({<status={'Acknowledged','transfered','suspended'}>},inno)

resolved=count({<status={'resolved','closed'}>},inno)

[sunny_talwar]

You should be able to filter if you use these expressions.....

Count({<status *= {'Acknowledged','transfered','suspended'}>} inno)

Count({<status *= {'resolved','closed'}>} inno)

[mshailaja]

like this error im  getting

[sunny_talwar]

Expression editor doesn't understand the syntax, but the expression should work... Have you tried clicking okay to check if it gives the output you are hoping for?

[mshailaja]

yes, but not working..

My actual requirement is

filetr is not working as i hardcoding in the set analysis .

i want those  expressions(formaulas written in  script level)

please help..

[sunny_talwar]

Would you be able to share a sample?