Use this box to customize the minimum or maximum gauge limit.
For more information, see "Gauge Properties dialog: Scale tab."
Components
Gauge Limit
Use this box to specify the custom gauge limit by selecting one of the following options:
Static Value — Select this option to specify a static value, such as 1000. You can specify either an actual value or a percentage. The value you specify depends on the range of data points. For example, the maximum gauge limit should be more than the maximum data point so that all data points are shown on the gauge.
Variable Expression — Select this option to specify a string. When you select this option, the Default Value field is displayed in which you enter the string.
You can reference one or more variables in the string (or expression). For example, you might reference a presentation variable named MaxSales. For guidelines on referencing a variable in an expression, see Table 2-2. For more information on variables, see "Using Variables."
Column — Select this option to specify a measure column and then select the name of the column, for example, Dollars.
Note: Only columns that are in the metadata repository or that are based on repository columns (such as Dollars*0.10) are displayed as selections. |
SQL Statement — Select this option to specify a SQL statement and enter the SQL statement, for example:
"Sales Measure"."Year Ago Dollars"*10