4 Replies Latest reply: Apr 3, 2018 1:31 PM by Josefina Fasoli RSS

    Aggr on a graph - incorrect values

    Josefina Fasoli

      Hello everyone,

       

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

       

      KPI.PNG

       

      Its formula is

      formula.PNG

       

       

      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)

       

      Graph.PNG

       

       

      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.

       

      why.PNG

       

      Any help on this would be very appreciated.

      Thanks,

      Josefina