topic Re: Aggr on a graph - incorrect values in App Development

Aggr on a graph - incorrect values

Anonymous — Tue, 03 Apr 2018 17:21:17 GMT

Hello everyone,

I have a KPI that shows average travel days (Días promedio de viaje).

Its formula is

When I take the same expression and remove the date filters to use it in a chart by month year the values are not the same as the ones showed on the KPI (as I expected)

The weird thing is when I filter a month the graph shows the same nuber as the KPI. It suggests me an issue with the Key and the dates but I am not finding what exactly can be the problem.

Any help on this would be very appreciated.

Thanks,

Josefina

Re: Aggr on a graph - incorrect values

sunny_talwar — Tue, 03 Apr 2018 17:25:00 GMT

May be you need to add Mes Ano as one of the dimension to your aggr function....

Re: Aggr on a graph - incorrect values

Anonymous — Tue, 03 Apr 2018 17:26:44 GMT

Hi Sunny, thanks for your answer.

The dimension on the graph is mes año

Re: Aggr on a graph - incorrect values

sunny_talwar — Tue, 03 Apr 2018 17:28:00 GMT

Right, can you add that to the Aggr() function also?

Avg({<....>}Aggr( ....., movil, [Mes Ano]))

Re: Aggr on a graph - incorrect values

Anonymous — Tue, 03 Apr 2018 17:31:29 GMT

It worked! Thank you so much!