22 Replies Latest reply: Mar 24, 2016 5:43 AM by Hans de Vries RSS

    Set analysis expression as dynamic max in line graph?!?

    Hans de Vries

      Hi all,


      In my line graph I plot according to this expression:

      sum ({1<[Schadecategorie] = {'A','B','C','D','E','F','G','H'}>} [Reserve bedrag in €] / 1000000)

      I thought that a clever way of making sure the graph would always display properly, was making use of this expression:


      max(aggr(sum({1 <[Schadecategorie] = {'A','B','C','D','E','F','G','H'}>}[Reserve bedrag in €] / 1000000),Peildatum))


      But for some reason, the line goes above (and out of) the chart. Dimension in this chart is Peildatum.


      When I add 4.5 mln. to the max() expression, it's OK. What am I doing wrong?