Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I wanted consider the values by comparing two fields which i am doing by Possible value in set analysis .
Count({<category=P(SubCat)>}ID).
but this is not considering the exact field match value . Can you please help me in getting the exact field value match
Thanks in Advance
Set analysis does a column-level evaluation. If you need a row-level evaluation you need to use an if-loop, maybe like:
if(category=SubCat, Count(ID))
- Marcus
Thanks for the reply Marcus ,
I am using the expression is something like this and tried to implement your logic as shown below but this doesn't give me any value , can you please suggest me where exactly I am going wrong ?
if(category=SubCat),
Aggr(
count(Distinct {<STATUS-={'Delivered'},
SEVERITY_NAME={'1 - Critical','2 - High'}>}
if(CREATE_DATE<IntDate and (isnull(CLOSE_DATE) or CLOSE_DATE>=IntDate),ID)),''))
Thanks
Hi Expertise
Any help on my post
Thanks
The expression is syntactically correct but may be logically incorrect in context of the actual data
Also I would suggest creating flags in your data for below conditions so you can use the flag fields in your expression
if(CREATE_DATE<IntDate and (isnull(CLOSE_DATE) or CLOSE_DATE>=IntDate),1,0) as flagDateCriteria
If(category=SubCat,1,0) as flagcategoryCriteria
Then use flags in set analysis as below
count(Distinct {<STATUS-={'Delivered'},
SEVERITY_NAME={'1 - Critical','2 - High'},
flagDateCriteria={1},
flagcategoryCriteria={1}
>} ID)
Please post some sample data
IMO the expression is quite wrong - logically and syntactically because of the missing outer aggregation of the aggr(), also the dimension within the aggr() is missing, the first if-loop condition ends with a bracket, ...
I would rather try something like this:
if(CREATE_DATE < IntDate and
(isnull(CLOSE_DATE) or CLOSE_DATE >= IntDate) and
category=SubCat,
count(Distinct {<STATUS-={'Delivered'}, SEVERITY_NAME={'1 - Critical','2 - High'}>} ID)
- Marcus