Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
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:
In profiler of y, show desirability functions:
Control+click (in windows) on the desirability function, set it to maximize and give it a range to search:
Adjust the axis settings and then run maximize desirability:
Which does identify the value of X that maximizes Y: