Chart with benchmark, how to implement dynamic min/max scale for axis

[Anonymous]

Hello,

I have a chart with an Benchmark calculation as attached.

Due to a better view on the values I try now to implement a dynamic scale in this chart.

I found the example to set static min and static max fields using expressions that take the min/max value of an aggregation.

For example:

Min ( Aggr ( Sum ( valuefield ) , DateTimeField ))

Max ( Aggr ( Sum ( valuefield ) , DateTimeField ))

Source: Scaling dynamic axes on a chart

But if I try to implement this in the attached file it doesn't work?

If anyone has an advice I would be very thankful!

Many thanks and best regards

Claus

[sunny_talwar · Accepted solution]

Looking to get this?

Static Min

=RangeMin(Min(Aggr(Sum({1}SALES), PERIODE, AREA)), Min(Aggr(Avg({1}SALES), PERIODE)))

Static Max

=RangeMax(Max(Aggr(Sum({1}SALES), PERIODE, AREA)), Max(Aggr(Avg({1}SALES), PERIODE)))

[Anonymous]

Many thanks Sunny,

this is exactly what I searched!

But for a better view on the min/max values I would use the adjusted formulas.

Best regards,

Claus

Static Min

=RangeMin(Min(Aggr(Sum({1}SALES), PERIODE, AREA)), Min(Aggr(Avg({1}SALES), PERIODE))) *0.9

Static Max

=RangeMax(Max(Aggr(Sum({1}SALES), PERIODE, AREA)), Max(Aggr(Avg({1}SALES), PERIODE))) *1.1

[sunny_talwar]

Awesome