Aggr on a graph - incorrect values

[Anonymous]

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

[sunny_talwar]

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

[Anonymous]

Hi Sunny, thanks for your answer.

The dimension on the graph is mes año

[sunny_talwar · Accepted solution]

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

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

[Anonymous]

It worked! Thank you so much!