You can highlight metric data in a visualization by displaying the data in a different font color, or by replacing it with an image. For example, a Grid visualization displays revenue data for different geographical regions. You can use thresholds to display revenue values less than $500,000 in red. Thresholds can make analyzing large amounts of data easier because images are easy to locate and different font colors are quickly identified.
A threshold is made up of two parts: the condition, and the formatting that will be applied to the values that meet the condition. Conditions can vary in complexity depending upon the type of threshold that is created. The data that meets the condition is considered to be data that has passed the threshold of the condition. Once data passes the threshold, formatting is automatically applied to the data.
Steps are below to create or remove a threshold in a visualization.
To create a threshold for a metric:
The following procedure assumes that you have already created the visualization with the metric that you want to create a threshold for.
You must have Edit Dashboard and Run Dashboard privileges.
From the visualization's Drop Zones panel, hover the cursor over the name of the metric you want to define a threshold on, then click the arrow icon on the right. A list of options is displayed.
Select Thresholds. The Thresholds dialog box opens.
From the Show drop-down list, select the type of formatting you want to apply to metric values that meet the threshold condition, as follows:
To create a threshold to change the background color used to display metric values, select a set of colors to apply to the values, such as Green or Red.
To replace metric values with an image, select Images. From the second drop-down list, select the images you want to display. The options include:
Arrows
Regular Pin
Rounded Pin
From the Based on drop-down list, select the metric to use to define the threshold.
From the next drop-down list, select one of the following:
To create a threshold based on the value of the metric, select Value. For example, you can display metric values greater than 5 million in blue.
To create a threshold based on the top x metric values, select Highest. For example, you can display the top 5 metric values in red.
To create a threshold based on the bottom x metric values, select Lowest. For example, you can display the bottom 5 metric values in green.
To create a threshold based on the top x percent of metric values, select Highest %. For example, you can display the top 10% of metric values with a green flag.
To create a threshold based on the bottom x percent of metric values, select Lowest %. For example, you can display the bottom 50% of metric values with a red flag.
From the Break By drop-down list, select the attribute level at which you want to restart counting rank or percent values for the metric. This option is only available for thresholds based on rank or percent values.
Each band displayed in the dialog box represents a different range of values. You can click and drag a thumb left or right along the slider to increase or decrease the range of values covered by the band.
Do one of the following:
To create a new band, press CTRL and click a band to divide it into two separate bands.
To change the color applied to the range of values covered by a band, double-click the band, then select the new color from the palette.
To delete a band, hover the cursor over the band, then click the x icon. The band is deleted.
You can preview your changes by clicking Apply. Once you have finished defining the threshold, click OK. The threshold is created.
To clear all thresholds applied to a metric:
The following procedure assumes that you have already created a threshold for at least one metric in the visualization.
You must have Edit Dashboard and Run Dashboard privileges.
From the Drop Zones panel, hover the cursor over the name of the metric you want to clear thresholds for, then click the arrow icon on the right. A list of options is displayed.
Select Clear Thresholds. All thresholds defined for the metric are cleared, and no longer affect the display of data in the visualization.
Related topics
Creating a Visual Insight quick dashboard
Formatting visualizations
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices