Working with Key Values
About Key Values
A key value object displays one or more key values, each of which contains an aggregated value for a measure.
If no lattice category is assigned, then the aggregated value that is displayed is for the entire data query. For example, if the aggregation for your measure is Sum, then the key value displays the sum of all of the values in the data query.
If a lattice category is assigned, then the object contains a lattice of key values that represent each category value.
Data Roles for a Key Value
For information about setting data roles, see Working with Data Role Assignments in SAS Visual Analytics: Working with Report Data.
The basic data roles for a key value are a measure and a lattice category. The measure is required and the lattice category is optional.
In addition to the basic data roles, you can assign these roles:
- Data tip values
-
specifies data items whose values are included in the data tips for the object. Data items can be categories, measures, or both. If you change a measure’s aggregation, then the data tip reflects that change. For more information, see About the Data Tip Values Data Role in SAS Visual Analytics: Working with Report Data.
- Hidden
-
specifies a category or date data item that is included in the data query but that is not displayed. You can use the hidden data item when you map data sources, add color-mapped display rules, or add external links. For more information, see About the Hidden Data Role in SAS Visual Analytics: Working with Report Data.
Options for a Key Value
For information about general options, see Using the Options Pane.
In addition to the general options, you can specify the following object-specific options in the Options pane:
- Style
-
specifies the style for the key value. Select Text to display the values only. Select Infographic to display the values within a colored circle.
- Sort
-
specifies the sorting of the key values in the lattice. Specify one of the following:
- Highest ranked value
-
sorts the lattice in descending order by the aggregated measure value.
- Lowest ranked value
-
sorts the lattice in ascending order by the aggregated measure value.
- Alphabetical
-
sorts in the lattice in ascending alphabetical order by the category value.
- Reverse alphabetical
-
sorts in the lattice in descending alphabetical order by the category value.
Note: This option has no effect if a lattice category is not assigned to the object. - Highlight
-
specifies whether the category value or the measure value is highlighted. The highlighted value is displayed in a larger font. In the Text style, the highlighted value is displayed above the other value. In the Infographic style, the highlighted value is displayed at the center of the circle. The other value is displayed only if you select the value in the Additional information option.
For the Infographic style only, you can specify text style options for the highlighted value. (For the Text style, these options are available elsewhere.)
- Position
-
specifies the position of the content within the object.
- Row limit
-
specifies a maximum number of rows for the lattice if a lattice column is assigned.
- Column limit
-
specifies a maximum number of columns for the lattice if a lattice column is assigned.
- Lattice layout
-
specifies whether the lattice is laid out by columns
or by rows 
. - Abbreviate numerical values
-
displays the measure values in an abbreviated form. For example, the value 1,142,571 might be abbreviated as 1.1M. The data tip for the measure always displays the full value. You can set the scale and precision of the abbreviated values.
If you select the Text style, then the following additional options are available:
- Alignment
-
Specifies the alignment of the labels and values.
- Measure label
-
displays the measure label. If enabled, then you can specify text style options for the measure label.
- Measure value
-
displays the measure value. If enabled, then you can specify text style options for the measure value.
- Lattice category label
-
displays the lattice category label. If enabled, then you can specify text style options for the category label.
- Lattice category value
-
displays the lattice category value. If enabled, then you can specify text style options for the category value.
- Aggregation
-
displays the aggregation for the measure value. If enabled, then you can specify text style options for the aggregation label.
If you select the Infographic style, then the following additional options are available:
- Additional information
-
specifies a single label or value to display in addition to the measure value. If enabled, then you can specify text style options for the label or value.
- Circle
-
specifies the color of the circle.