2 Replies Latest reply: Nov 15, 2017 7:28 AM by Sunny Talwar RSS

    Aggr() alternative to avoid grain mismatch

    Litin Kumar

      I'm trying to use the aggr() function in order to calculate a metric using  this expression- sum(aggr(count({<A = 'a'>}X),Y)).

      I'm using this expression in a chart object and also in  KPI box. The chart object has Finer dimension(Month leve;) than 'A'.

      Because of this the values that show up are incorrect.

       

      Is there an alternative to aggr() to overcome this issue