8 Replies Latest reply: Nov 28, 2012 11:20 AM by Licquor RSS

    Average of capped aggregation expression required

      Hi,

       

      I want to produce an average by day of a calculated % by interval. To complicate matters though, where the % of any interval exceeds 105% I want to cap it at this level so as not to skew the result.

       

      e.g.

       

      1/11/2012     8:00     120%

      1/11/2012     8:30     95%

      1/11/2012     9:00     100%

       

      I want to get 100% as a daily result