1 Reply Latest reply: Sep 27, 2015 5:57 AM by Marcus Sommer RSS

    Optimized Expression for given exp

    Praveen Kumar Konda

      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