Heat Maps

Heat maps are based on one metric and two attributes. Heat maps are supported by all Composer data connectors except Cloudera Search. They are supported by Composer Apache Solr connectors for version 5.2 or later.

This topic describes:

Configuring Default Heat Map Settings for a Data Source

To configure the default heat map settings for a data source configuration:

  1. Edit the appropriate data source configuration. See Editing a Data Source Configuration.

  2. Select the Visuals tab in the data source configuration wizard.

  3. On the Standard subtab of the Visuals tab, select Heat Map.

    If you want to be able to display the data collected by this data source configuration as a heat map, make sure the Heat Map checkbox is selected.

    Default heat map settings appear on the right side of the page.

  4. Configure the default settings as follows:

    Setting Description
    Rows

    Select the attribute by which row (x-axis) data should be grouped.

    If you select a date or time attribute, a second box appears to the right for this setting. Use this second box to specify the date and time granularity used to group the data. Valid granularities are Millisecond, Second, Minute, Hour, Day, Week, Month or Year.

    If some of these granularity options do not appear, verify that the granularity specified for this field on the Fields tab is set at the correct granularity level. For each field, the available granularity options include all options starting from Year down to the granularity level specified for this field on the Fields tab.

    The refinement level of the field data in a data store defines the minimum level of granularity that should be set for the field. Specifying granularity for a field that is lower than the refinement level of the field data will not produce a visual with data grouped at the requested lower level. For example, if a field's data is stored in hours, requesting the granularity of that data lower than hours will produce the values up to the hour level, and the more detailed level information will be zeros (i.e., 0 minutes, 0 seconds, and 0 milliseconds).

    Rows Limit Specify the number of row (x-axis) attribute items to display on the visual.
    Rows Sort Select a row (x-axis) metric or attribute by which the row items should be sorted. You can also select the sorting order (Ascending or Descending). For metrics, you can define the default aggregation function: SUM, AVG, MAX, or MIN. See Available Metric Functions.
    Columns

    Select the attribute by which column (y-axis) data should be grouped.

    If you select a date or time attribute, a second box appears to the right for this setting. Use this second box to specify the date and time granularity used to group the data. Valid granularities are Millisecond, Second, Minute, Hour, Day, Week, Month or Year.

    If some of these granularity options do not appear, verify that the granularity specified for this field on the Fields tab is set at the correct granularity level. For each field, the available granularity options include all options starting from Year down to the granularity level specified for this field on the Fields tab.

    The refinement level of the field data in a data store defines the minimum level of granularity that should be set for the field. Specifying granularity for a field that is lower than the refinement level of the field data will not produce a visual with data grouped at the requested lower level. For example, if a field's data is stored in hours, requesting the granularity of that data lower than hours will produce the values up to the hour level, and the more detailed level information will be zeros (i.e., 0 minutes, 0 seconds, and 0 milliseconds).

    Columns Limit Specify the number of column (y-axis) attribute items to display on the visual.
    Columns Sort Select a column (y-axis) metric or attribute by which the column items should be sorted. You can also select the sorting order (Ascending or Descending). For metrics, you can define the default aggregation function: SUM, AVG, MAX, or MIN. See Available Metric Functions.
    Color Metric Select the metric that affects the segment color in the visual. You can also define the default aggregation function used for the metric values: SUM, AVG, MAX, MIN, or (for some data sources) LAST VALUE. See Available Metric Functions.
  5. Select .

Configuring Settings for a Specific Heat Map

To change the settings for a specific heat map:

  1. Edit the heat map you want to modify. See Editing Visuals.

  2. If you are editing the visual in a dashboard, select Edit Visual from the visual drop-down menu. The sidebar menu for the visual appears.

    If you are editing the visual from the Visual Gallery, the sidebar appears to the right of the visual.

  3. Select on the sidebar menu. The Heat Map Settings sidebar for the visual appears.

  4. Alter the settings as needed:

    Setting Description
    Show Values Slide the Show Values slider on (to the right) to show the number of records (volume) in heat map cells.
  5. Select to save the dashboard and the visual with its updated settings.

Configuring Colors for a Specific Heat Map

To specify the color settings for a specific heat map using the Color sidebar

  1. Edit the visual you want to modify. See Editing Visuals.

  2. If you are editing the visual in a dashboard, select Edit Visual from the visual drop-down menu. The sidebar menu for the visual appears. If you are editing the visual from the Visual Gallery, the sidebar appears to the right of the visual.

    Select on the sidebar menu. The Color sidebar for the visual appears.

  3. Configure the color settings as described below. As you change the color settings, the legend at the top of the Color sidebar shows how the legend will appear on the visual. Supported color specifications are described in Specifying Colors.

    Setting Description
    Legend Slide the bar to the right if you want the legend to be displayed on the visual or to the left to hide the legend.
    Color Metric Select the metric that affects the segment color in the visual.
    Color Palette If a color palette is specified for this visual type in the data source defaults, select the color palette for this specific visual. If a color range is selected for visuals in the data source defaults, this setting is not available.
    Color Mode

    Select Distinct Colors or Gradient to identify the way colors are used on the screen. Either specific distinct colors will be used or a gradient of colors will be used.

    (This is equivalent to the Legend Type default settings on the Visuals tab of the data source configuration.)

    Threshold Mode If you selected the Gradient color mode, this setting cannot be changed. If you selected the Distinct Colors color mode, select either Auto or Manual from the drop-down list. Auto will automatically assign thresholds and colors for the visual. Manual allows you to change the thresholds and colors used on the visual.
    Number of colors Specify the number of colors to use for the visual.
    Color Rules Color rules allow you to change the colors for each color used for the visual. In addition, if you specified a Manual threshold mode, you can select the thresholds used for color settings in the visual. See Understanding Visual Color Condition Thresholds.
  4. Close the Color sidebar and the color settings are dynamically applied to the visual.

  5. Select to save the dashboard and the visual with its updated settings.

Understanding Visual Color Condition Thresholds

You can set threshold color conditions for metric-based visuals. At least two color settings are required. In addition, thresholds are specified between each color setting. (So three color settings require two threshold settings; four color settings require three threshold settings, etc.)

  • The color for Color 1 is used when the value of the color metric is less than the first threshold value.

  • The color for Color 2 is used when the value of the color metric falls between the first and second threshold values.

  • If only three colors are used for the visual, the color for Color 3 is used when the value of the color metric is greater than or equal to the second threshold value.

    If more than three colors are used, the color for Color 3 is used when the value of the color metric falls between the second and third threshold values.

    When more than three colors are used, the colors continue to be applied in this pattern for all threshold settings; any color metric values greater than the last threshold setting have the final color applied.

You can have Composer automatically set the thresholds or you can manually set them.

For information about the color encoding supported by Composer, see Specifying Colors.