Hi,
I've a straight table that uses most/all of the following set analysis calculation. they are same/similar but is used for different data point.
if($1=1,
Count({
<[SDType]={'EOA'}, [PDStatus]={'EDComplete*'}>
*
((<[PADate]={'>=$(=vADateEOA)'},
[DStatus]-={'EDComplete', 'ED Complete - Pending System Updates'}>)
+
<[QARev]={'Pending'}>)
*
(<[QARev]-={'NFTA', 'Waived'}, [Action Needed]-={'QA2Rev'}>)
} [CPTYDoc: DocID])
, if($1=3,
'SF - ' &
MaxString({
<[SDType]={'EOA'}, [PDStatus]={'EDComplete*'}>
*
((<[PADate]={'>=$(=vADateEOA)'},
[DStatus]-={'EDComplete', 'ED Complete - Pending System Updates'}>)
+
<[QARev]={'Pending'}>)
*
(<[QARev]-={'NFTA', 'Waived'}, [Action Needed]-={'QA2Rev'}, [CPTYDoc: ID]>)
}[CPTYDoc: DocID]) &
$(vSFURLPart1) &
MaxString({
<[SDType]={'EOA'}, [PDStatus]={'EDComplete*'}>
*
((<[PADate]={'>=$(=vADateEOA)'},
[DStatus]-={'EDComplete', 'ED Complete - Pending System Updates'}>)
+
<[QARev]={'Pending'}>)
*
(<[QARev]-={'NFTA', 'Waived'}, [Action Needed]-={'QA2Rev'}, [CPTYDoc: DocID]>)
}[CPTYDoc: ID]) &
$(vSFURLPart2)
, if($1=4,
If(IsNull(MaxString({
<[SDType]={'EOA'}, [PDStatus]={'EDComplete*'}>
*
((<[PADate]={'>=$(=vADateEOA)'},
[DStatus]-={'EDComplete', 'ED Complete - Pending System Updates'}>)
+
<[QARev]={'Pending'}>)
*
(<[QARev]-={'NFTA', 'Waived'}, [Action Needed]-={'QA2Rev'}, [CPTYDoc: DocID]>)
}[FNDURL])),'',
MaxString({
<[SDType]={'EOA'}, [PDStatus]={'EDComplete*'}>
*
((<[PADate]={'>=$(=vADateEOA)'},
[DStatus]-={'EDComplete', 'ED Complete - Pending System Updates'}>)
+
<[QARev]={'Pending'}>)
*
(<[QARev]-={'NFTA', 'Waived'}, [Action Needed]-={'QA2Rev'}, [CPTYDoc: DocID]>)
}[FNDURL_Link]))
, if($1=5,
'PSF - ' &
MaxString({
<[SDType]={'EOA'}, [PDStatus]={'EDComplete*'}>
*
((<[PADate]={'>=$(=vADateEOA)'},
[DStatus]-={'EDComplete', 'ED Complete - Pending System Updates'}>)
+
<[QARev]={'Pending'}>)
*
(<[QARev]-={'NFTA', 'Waived'}, [Action Needed]-={'QA2Rev'}, [CPTYDoc: ID]>)
}[Main Doc ID]) &
$(vSFURLPart1) &
MaxString({
<[SDType]={'EOA'}, [PDStatus]={'EDComplete*'}>
*
((<[PADate]={'>=$(=vADateEOA)'},
[DStatus]-={'EDComplete', 'ED Complete - Pending System Updates'}>)
+
<[QARev]={'Pending'}>)
*
(<[QARev]-={'NFTA', 'Waived'}, [Action Needed]-={'QA2Rev'}, [CPTYDoc: DocID]>)
}[MDCharID]) &
$(vSFURLPart2)
,if($1=6,
MaxString({
<[SDType]={'EOA'}, [PDStatus]={'EDComplete*'}>
*
((<[PADate]={'>=$(=vADateEOA)'},
[DStatus]-={'EDComplete', 'ED Complete - Pending System Updates'}>)
+
<[QARev]={'Pending'}>)
*
(<[QARev]-={'NFTA', 'Waived'}, [Action Needed]-={'QA2Rev'}>)
} [PADate])
,if($1=7,
MaxString({
<[SDType]={'EOA'}, [PDStatus]={'EDComplete*'}>
*
((<[PADate]={'>=$(=vADateEOA)'},
[DStatus]-={'EDComplete', 'ED Complete - Pending System Updates'}>)
+
<[QARev]={'Pending'}>)
*
(<[QARev]-={'NFTA', 'Waived'}, [Action Needed]-={'QA2Rev'}>)
} [PDStatus])
)
)
)
)
)
)
All calculations are working fine and is providing right data. It is just taking too long (close to 3-5 minutes for 500 records in the table). I had created these calculations using help from question posted in need help with managing variation of similar set analysis expression for maintainability, performanc....
I'm looking for guidance to reduce chart load time. It will be big a help.
Thanks & Regards,
Vijay
