Use this dialog to set the value for one of the following items for a graph:
Position of a line scale marker
Low value of a range scale marker
High value of a range scale marker
To set the value, you can use a static value, a presentation variable, a measure column, or a SQL query. If a value is not valid, then the scale marker is ignored.
For more information, see "Scale Markers dialog."
Components
Static Value
Use this option to set the value to a hard-coded value that you specify. If you select this option, then enter the hard-coded value in the field to the right of the option.
Variable Expr
Use this option to set the value to the value of a presentation variable. If you select this option, then enter the presentation variable in the field to the right of the option and a default value in the (default) field.
Column Name
Use this option to set the value based on a measure column. If you select this option, then select the measure column in the box to the right of the option.
Note that using a measure column could yield numerous values. Only the first value is applied.
SQL Query
Use this option set the value based on the results of a SQL query. If you select this option, then enter the SQL query in the box beneath the option.
Note that the results could be a table but only the first row and first column cell value is applied.