Discovery Summit 2026: Early User Edition - September 23-24.Register. It's free.
Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
When working interactively you might do this with the profiler. Create a column with the formula you want to maximize, then open the profiler, set desirability functions, and then maximize desirability.
Table with formula:
ih_0-1690219205203.png
In profiler of y, show desirability functions:
ih_1-1690219242442.png
Control+click (in windows) on the desirability function, set it to maximize and give it a range to search:
ih_2-1690219373121.png
Adjust the axis settings and then run maximize desirability:
ih_3-1690219443737.png
Which does identify the value of X that maximizes Y: