To format values according the required condition:
-
Click the measure menu button, select Add Format Rule | Gradient Ranges and choose the required color gradient.
The Gradient Ranges dialog box is displayed, containing the set of value ranges and corresponding appearance settings. The Grid dashboard item on the right displays the default formatting applied using the predefined red-blue gradient.
This dialog allows you to change the following options specific to Gradient Ranges.
-
Number of ranges allows you to specify the number of ranges used to classify values. Click the Generate Ranges button to generate a new gradient scale according to the specified number of ranges.
-
The Use % ranges check box specifies whether the percent or absolute scale is used to generate ranges.
Note:The Use % ranges option is not available for date-time dimensions.
-
-
To change the specific color in the gradient, click the button next to the required color. Select a new color or specify a custom background color. This allows you to create a color gradient based on more than two colors.
To learn how to specify a custom color, see Specifying Appearance Settings.
-
Change range boundaries by specifying the required values by typing the new boundaries into the desired fields.
Note:A new value should fall into a range between corresponding values of the previous and next range.
-
To change the comparison logic for the required range, click the comparison sign and select the required option.
The > =(greater or equal to) sign indicates that the range includes the smallest value of the current interval while the >(greater) sign indicates that the range excludes the smallest value from the current interval and includes it in the next interval.