How to get the max value of an axis?

[Marcio_Campestrini]

Hi everybody!

I have an issue. Ther's an application with a graph that have two expressions, one on each axis. I received a request that the maximum value of the right axis should be proportional to the maximum value of the left axis. So I ask, there's a way to get this value and use it in a formula?

Thanks in advance!

[tresesco]

May be simply like: =max(YourDimensionInAxis)

[Marcio_Campestrini]

Tresesco.

Thansk for the answer, but I didn't got what you mean with YourDimensionInAxis? Is it the expression name?

If it helps, I want the value 110, in the image below.

[#4]

Or you can use the Max(Column) {Where column : It will have the value coming from the expression}

[Marcio_Campestrini]

Rishi, it doesn't seems to work.

[Marcio_Campestrini · Accepted solution]

Hello.

I use the following formula and it worked.

=(max(aggr(count(DISTINCT <first axis expression>), <field_name>)) * 1.20) / 10

With this, I made the second x-axis proportional to the first.

Thanks