2 Replies Latest reply: Jan 7, 2016 6:58 AM by Christoph Hebig RSS

    KPI max value and depending date

    Christoph Hebig

      Hi there,

       

      i got another problem. I have a KPI Value "Max(aggr(sum(pallets), time))" and for the second value on the same KPI i want the Date, when this value appears.

      So e.g. max would be 15 and the date 1.1.2016.

       

      I tried different things but it never worked... I am this far at the moment:

       

      Max({$<Pallets = {'$(=Max(Aggr(Sum(Pallets), time)))'}>}time)

       

      I think i may know the problem, which is that my part in {}-Brackets will give a sum and not a single Pallet number. Is there a way to filter for a sum in that part?

       

      Thanks in advance!

      Regards

      Chris