5 Replies Latest reply on Nov 15, 2018 5:16 AM by Jaroslaw Cichon

    aggregating values by max/min date

    Jaroslaw Cichon

      Hi,

      I have data with different kpis of products like this:

        

      dateProductkpivalue
      2018-01-01product1kpi1223
      2018-01-01product1kpi24234
      2018-01-01product1kpi35433
      2018-01-01product1kpi42334221
      2018-02-01product1kpi1241
      2018-02-01product1kpi24532
      2018-02-01product1kpi34987
      2018-02-01product1kpi42335254

       

      While having date in filter I want to get sums of value for kpi1, kpi2, kpi3, but for kpi4 I need just the value based on max date - so in this case when i filter months 1 and 2, in kpi4 should be 2335254 and when i filter only month 1, kpi4 should be 2334221 (for other kpis there should be sums). Is it possible to achieve that view?