topic Re: Set analysis help in App Development

Set analysis help

dandaanilreddy — Tue, 19 Jul 2022 01:25:45 GMT

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

Re: Set analysis help

sidhiq91 — Tue, 19 Jul 2022 03:09:10 GMT

@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.

Re: Set analysis help

MayilVahanan — Tue, 19 Jul 2022 04:17:14 GMT

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)

Re: Set analysis help

dandaanilreddy — Tue, 19 Jul 2022 15:58:43 GMT

@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

Re: Set analysis help

BrunPierre — Tue, 19 Jul 2022 17:59:43 GMT

@dandaanilreddy May this;

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

Re: Set analysis help

dandaanilreddy — Tue, 19 Jul 2022 18:24:07 GMT

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

Re: Set analysis help

BrunPierre — Tue, 19 Jul 2022 20:23:35 GMT

Could you share a sample and the output desired?