Thresholds Editor for dashboards
You can highlight metric data in a visualization by displaying the data
in a different color or replacing the data with an image. For example,
a Grid visualization displays revenue data for different geographic 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
different data 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 multiple thresholds, including thresholds with multiple conditions
that can be based on attributes as well as metrics, see Advanced
Thresholds Editor for dashboards.
Prerequisites
You have
already created the visualization with the metric that you want to
create a threshold for. For steps, see About
visualizations.
You have
already created the visualization with the metric that you want to
create a threshold for. For steps, see About
visualizations.
To create a threshold for a metric:
Click the name of the dashboard
to run it, then click the visualization to create a threshold for.
From the visualization's Editor
panel, right-click the name of the metric that contains the values
to format based on the threshold condition. Select Thresholds.
The Thresholds Editor opens. Note:
If the Editor panel is not displayed, from the View
menu, ensure that Editor Panel
is selected. If the Editor panel is hidden behind another panel, click
the Editor icon 
to display the Editor panel.
Define the formatting to apply
to your data as follows:
If the Thresholds
Type option is displayed, select one of the following:
To display
your data using different colors based on the value of the metric,
select the Color-based option.
From the Color drop-down list,
select a set of colors to apply to the values, such as Green
or Red.
To replace
your data with images based on the value of the metric, select the
Image-based option. From the
Images drop-down list, select
a set of images to replace the values with, such as Arrows
or Rounded Push Pin.
If the Thresholds
Type option is not displayed, from the Color
drop-down list, select a set of colors to apply to the values, such
as Green or Red.
To quickly reverse the order of
colors or images used to display data that falls within each range,
click Reversed. For example,
if small, medium, and large data values are displayed in green, yellow,
and red respectively, you can quickly choose to display small values
in red, medium values in yellow, and large values in green.
From the Based
on drop-down list, select the metric to base the threshold
condition on.
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 in blue.
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 in orange.
If the Break By option is displayed,
from the Break By drop-down
list, select one of the following:
To select
the attribute level at which to restart counting rank or percent values
for the metric, select the name of the attribute. This option is only
available for thresholds based on rank or percent values.
To continue
counting rank or percent values without restarting, select None.
You can determine the formatting
applied to metric values across a specific range of values. Each band
displayed in the threshold slider represents a different range of
metric values. The color or image displayed above the band represents
the formatting used to display values that fall within its range.
Choose from the following:
To increase
or decrease the range of a band on the threshold slider, click and
drag the thumb at the end of a band to the end of its new range.
To change
the location of a thumb to a specific value, click the thumb. Double-click
the value displayed above the thumb, then type the value and press
ENTER.
For thresholds that change the
color used to display data, you can select the color to apply to a
specific range of values, define new bands, and so on. Choose from
the following:
To create
a new band, right-click the band to split and select Add
Color Band. The selected band is divided evenly into two separate
bands. You can then change the band’s range, as described above
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, right-click the band and select Delete.
The band is deleted.
To delete
a thumb, right-click the thumb and select Delete.
The thumb is deleted.
Click OK
to apply your changes. The threshold is created.
To clear all thresholds applied to a metric:
Prerequisites
From the Editor panel, right-click the name of
the metric you want to clear thresholds for, then select Clear
Thresholds. All thresholds defined for the metric are cleared,
and no longer affect the display of data in the visualization.
Related topics
About Visual
Insight in Flash
Creating a dashboard
Formatting visualizations
Advanced
Thresholds Editor for dashboards
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices