Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=num(Count(if(ReviewInMonth='Y' and WildMatch(ArrangeName,'BR/FR Mechanism,'SCOPE DOCUMENT AND TEST PLAN Mechanism,'BUSINESS REQUIREMENTS Mechanism,'FUNCTIONAL REQUIREMENTS Mechanism,'MINOR DEVELOPMENT DOCUMENT Mechanism,'SCOPE DOCUMENT Mechanism) AND wildmatch(MutualStatus,'Reviewed-MTD','Open*','Resolved*'),PMKey)),'#,##0')
How to convert above expression in to SET Analysis. Please help me.
Hi you could create two flags in your load script for ArrangeName and MutualStatus such
if(wildmatch(ArrangeName,'BR/FR Mechanism,'SCOPE DOCUMENT AND TEST PLAN Mechanism,'BUSINESS REQUIREMENTS Mechanism,'FUNCTIONAL REQUIREMENTS Mechanism,'MINOR DEVELOPMENT DOCUMENT Mechanism,'SCOPE DOCUMENT Mechanism),'Y','N') as ArrangeName_Flag
and
if(wildmatch(MutualStatus,'Reviewed-MTD','Open*','Resolved*'),'Y','N')as MutualStatus_Flag
Then in your expression would just be
num(Count({<[ReviewInMonth]={'Y'}, ArrangeName_Flag={'Y'},MutualStatus_Flag={'Y'}>}PMKey),'#,##0')
Like this:
Count({<ReviewInMonth = {Y},
ArrangeName = {'BR/FR Mechanism,'SCOPE DOCUMENT AND TEST PLAN Mechanism',
'BUSINESS REQUIREMENTS Mechanism', 'FUNCTIONAL REQUIREMENTS Mechanism',
'MINOR DEVELOPMENT DOCUMENT Mechanism', 'SCOPE DOCUMENT Mechanism'},
MutualStatus = {"Reviewed-MTD", "Open*", "Resolved*"}
>} PMKey)
You might have missed a single quote
Count({<ReviewInMonth = {Y}, ArrangeName = {'BR/FR Mechanism','SCOPE DOCUMENT AND TEST PLAN Mechanism',
'BUSINESS REQUIREMENTS Mechanism', 'FUNCTIONAL REQUIREMENTS Mechanism',
'MINOR DEVELOPMENT DOCUMENT Mechanism', 'SCOPE DOCUMENT Mechanism'},
MutualStatus = {"Reviewed-MTD", "Open*", "Resolved*"}
>} PMKey)