AverageIf function in Dashboards 4.0

You may also like...

8 Responses

  1. Ryan Goodman says:

    We actually recommend that customers be very careful with SUMIF, or COUNTIF because they are highly in-efficient in Xcelsius. For example, I had a customer today who built a dashboard on top of BW, and with a column of 1000 CountIf functions. The dashboard lagged for 15-20 seconds. Without CountIF it went down to less than one second after the query finishes. If used sparingly it is great but watch our for more complex tools.

    • Hi Ryan,

      Thanks for your addition, I agree with you. This solution can be used for a small set of data. I’ll write a note in the post to highlight this subject.

      Regards,
      Pieter

  1. October 3, 2012

    New blogpost on http://t.co/JEOrW5Jw: AverageIf function in Dashboards 4.0 http://t.co/bIryojrl #BI40 #Xcelsius #BOBJ #SAP

  2. October 3, 2012

    New blogpost on http://t.co/JEOrW5Jw: AverageIf function in Dashboards 4.0 http://t.co/bIryojrl #BI40 #Xcelsius #BOBJ #SAP

  3. October 3, 2012

    New blogpost on http://t.co/JEOrW5Jw: AverageIf function in Dashboards 4.0 http://t.co/bIryojrl #BI40 #Xcelsius #BOBJ #SAP

  4. October 3, 2012

    New blogpost on http://t.co/JEOrW5Jw: AverageIf function in Dashboards 4.0 http://t.co/bIryojrl #BI40 #Xcelsius #BOBJ #SAP

  5. October 3, 2012

    New blogpost on http://t.co/JEOrW5Jw: AverageIf function in Dashboards 4.0 http://t.co/bIryojrl #BI40 #Xcelsius #BOBJ #SAP

  6. October 4, 2012

    http://t.co/kLf1Nqfp » AverageIf function in Dashboards 4.0 http://t.co/cBtU8C2K

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.