Set analysis help

[dandaanilreddy]

Hello All,

I have a if condition expression like below and i want to ignore a field selection resource. Please can someone let me know how can i achieve this using set analysis? 

count(if(date(date#(due_date,'DD/MM/YYYY'),'DD-MM-YYYY')<date(Today(),'DD-MM-YYYY') and not wildmatch(status, 'Closed', 'Resolved'), resource)

Note: when user selects a value from resource field my Kpi should not reflect.

Thanks

[sidhiq91]

@dandaanilreddy  Please use the below expression to resolve the issue.

count({<due_date={"<=$(=Date(Date#(today(),'MM/DD/YYYY'),'DD-MM-YYYY'))"}, status-={'Closed','Resolved'}>}resource)

If this resolves your issues please like and accept it as a solution.

[MayilVahanan]

HI 
If you want to ignore the selection, you can add resource= in the set analysis.

Slight difference from Sidhiq solution,

count({<due_date={"<=$(=Date(Date#(today(),'MM/DD/YYYY'),'DD-MM-YYYY'))"}, status-={'Closed','Resolved'}, resource=>}resource)

[dandaanilreddy]

@MayilVahanan @sidhiq91  Thanks for your response. I have tried the expression but my KPI is showing zero. Ideally my value should be 2.

My due_date format is like 25/Jul/2022

count({<due_date={"<=$(=Date(Date#(today(),'MM/DD/YYYY'),'DD-MM-YYYY'))"}, status-={'Closed','Resolved'}, resource=>}ticket)

Thanks

[BrunPierre]

@dandaanilreddy  May this;

count({<due_date={"<=$(=Date(Date#(today(),'MM/DD/YYYY'),'DD/MMM/YYYY'))"}, status-={'Closed','Resolved'}, resource=>}ticket)

[dandaanilreddy]

Hi Peter,

Thank you for the response. I have tried above expression but still no luck. My due_date format is like 25/Jul/2022

[BrunPierre]

Could you share a sample and the output desired?