Static (dynamic) max on y axes

nboccassini — Wed, 08 Apr 2015 17:45:02 GMT

Hi all,

I want to set a dynamic value for a max axes. The automatic max value don't show the value as shown in image

The yellow expression is:

(((sum([FIELD A]+[FIELD B])) / Count(DISTINCT [FIELD C])) /

Above(((sum([FIELD A]+[FIELD A])) / Count(DISTINCT [FIELD C])))) -1

How I can calculate the max of this expression?

Re: Static (dynamic) max on y axes

sunny_talwar — Wed, 08 Apr 2015 17:57:41 GMT

Try something like this:

Max(Aggr(

(((sum([FIELD A]+[FIELD B])) / Count(DISTINCT [FIELD C])) /

Above(((sum([FIELD A]+[FIELD A])) / Count(DISTINCT [FIELD C])))) -1, yourDimension))

Best,

Sunny