topic Re: Set analysis expression is not working in App Development

Set analysis expression is not working

abc_18 — Tue, 21 Dec 2021 20:43:45 GMT

Hi,

To calculate a KPI in my dashboard, I am using below expression:-

count({$<[End Date]={">$(vDynamic)"} and [ created date]={"<$(vDynamic)"},[Population tag]*={' Extended Warranty','Service Contract'},
[ flag]*={'Population - 1','Population - 2','Population - 3','Population - 4',''},[contract]={' Contract'}>}Business)

But it's just giving me '-' blank value, can someone please tell me where I am doing wrong

Re: Set analysis expression is not working

Anil_Babu_Samineni — Fri, 26 Apr 2019 05:19:39 GMT

Perhaps this?

count({$<[End Date]={">$(vDynamic)"}, ~~and~~ [ created date]={"<$(vDynamic)"}, [Population tag]*={' Extended Warranty','Service Contract'}, [ flag]*={'Population - 1','Population - 2','Population - 3','Population - 4',''}, [contract]={' Contract'}>}Business)

Re: Set analysis expression is not working

Sameer9585 — Fri, 26 Apr 2019 09:09:48 GMT

try this?

count({$<[End Date]={">$(=$(vDynamic))"} +[ created date]={"<$(=$(vDynamic))"},[Population tag]*={' Extended Warranty','Service Contract'},
[ flag]*={'Population - 1','Population - 2','Population - 3','Population - 4',''},[contract]={' Contract'}>}Business)