topic Aggr() alternative to avoid grain mismatch in App Development

Aggr() alternative to avoid grain mismatch

litinkumar — Wed, 15 Nov 2017 09:06:50 GMT

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

vinieme12 — Wed, 15 Nov 2017 11:07:37 GMT

You can use TOTAL keyword

or maybe your AGGR() isn't working because you are not using the right field!

Add another keyfield that identifies each row uniquely and then try

example

sum(aggr(count({<A = 'a'>}X),KEYFIELD,Y))

sunny_talwar — Wed, 15 Nov 2017 12:28:51 GMT

Do you have a sample you can share to see the issue?