topic Re: Combo chart: same dynamic scale for both KPI's in App Development

Combo chart: same dynamic scale for both KPI's

7mon — Thu, 09 Mar 2023 13:11:20 GMT

Hi,

I'd like to display multiple KPI's in a combo chart, using the same dynamic scale.

Dependent on which KPI's has the highes value, the two scales should display the same maximum value.

We have unsucessfully tested the following statement in the max range:

if ( max(KPI_1) > max(KPI_2), max(KPI_1), max(KPI_2) )

Here we tried to enter the minimum and maximum scale for the KPI:

Many thanks for your support

Simon

Re: Combo chart: same dynamic scale for both KPI's

Or — Thu, 09 Mar 2023 13:17:25 GMT

You would need to use aggr() for this, since at the object level, e.g.

=RangeMax(Max(Aggr(KPI1,DimensionField)),Max(Aggr(KPI2,DimensionField)))

But that aside, why not just use a dynamic maximum if you're looking for it to match the highest value existing in the data?

Re: Combo chart: same dynamic scale for both KPI's

7mon — Thu, 09 Mar 2023 14:29:34 GMT

Hi Or,

many thanks for your quick reply.

So using RangeMax(Max(Aggr(...))) is used to define a dynamic maximum right..

It's working out properly btw 🙂

Thanks from Austria

Simon

Re: Combo chart: same dynamic scale for both KPI's

Or — Thu, 09 Mar 2023 14:52:43 GMT

RangeMax() is just a cleaner (and quicker) way to write this out rather than using If(Expr1>Expr2,Expr1,Expr2), since you don't have to write each expression out twice.