Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
May be simply like: =max(YourDimensionInAxis)
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.
Or you can use the Max(Column) {Where column : It will have the value coming from the expression}
Rishi, it doesn't seems to work.
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