Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)))
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)))
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
Awesome