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

[hansdevr]

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?

[hansdevr]

I understand.. But how can this be remedied? Alterations in reserve can indeed occur multiple times per day..

[Gysbert_Wassenaar]

Well, that depends on what you want to report per peildatum. Do you need a value of something only for the last transaction of the day? Or can you simply sum or count the measures even if there are multiple transactions per day?

Also, have a look at this blog post: Creating Reference Dates for Intervals‌. This may be a more convenient way to create the peildatum dates. In any case you should probably use the floor function on Startdatum to make sure you have a date that starts at midnight.

[hansdevr]

I'll send you an explanation per mail (in Dutch)..