Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
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)