Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Friends,
Can someone please help me with the optimized expression for below.
It is taking lot of time to process due to which my dashboard performance is very slow.
Optimized Expression for below:
If(
(Min({1}DEPTH)=Dimensionality() OR Dimensionality()=1) //get rid of the unwanted null rows
AND Count(RowNumber)>0, //this is used to make the chart filter properly
SubField(
Concat({1}Quantity,',',DEPTH), //Build comma delimited string of Partnumbers sorted by depth in hierarchy
',',1) //Subfield to only return the first partnumber from the comma-delimited string
)
Regards,
Praveen
I don't know sense well but I think you could your subfield-expression already create within the script and believe you didn't need those conditions to get rid of NULL.
- Marcus