Heatmap chart is a graphical representation of data where the individual values contained in a two dimensional matrix are represented as colors. It allows you to visualize distinctive areas or values among larger sets of data.

Open

Specify Heatmap Chart Details

To access a Heatmap chart, go to Analytics > Data Analyzer > Heatmap. The first tab Heatmap contains the result chart. The second tab, whose name is taken from the Data Label field contains the data that is shown in the chart.

You can specify the Heatmap chart details by doing the following:

1. Enter the name of the data series in the Data Label field (max 60 characters).

2. Choose a Data Source from the drop-down list. It can be any Pricefx data source – a Datamart, Data Feed, Simulation Datamart, Rollup or Optimization Model (DMT tables organized by Models to which they belong).

3. Select a Currency to which money data will be converted.

4. You can set up the Generic filter (all dimensions, dates and values):

   1. Click Add Generic filter, the Generic Filter dialog will open.

   2. Specify the filter criteria. You can combine individual rules with groups of rules as clauses and subclauses.

   3. Click Apply.

5. You can create an Aggregation filter that allows you to filter the Datamart query results, i.e., to determine, which values will be shown in the chart. Variables (columns) calculated as contribution cannot be selected in aggregation filter.

6. Product filter allows you to select products from the drop-down list or filter by all attributes from the product master data. You can use the quick filters under the table header, set up an advanced filter or select an attribute value in the table, which selects all products with the same attribute value. Attributes that are not available for filtering are grayed out.

7. Customer filter allows you to select customers from the drop-down list or filter by all attributes from the customer master data. You can use the quick filters under the table header, set up an advanced filter or select an attribute value in the table, which selects all products with the same attribute value. Attributes that are not available for filtering are grayed out. Only the filtered data will be used in the analysis.

8. You can set up a Dimension filter:

   1. Select the filter dimension from the drop-down list.

   2. Select the values to filter by.

   3. Add more dimensions if required. In all subsequent filters you will only be able to select values complying with all previous filters.

9. Define the axis X and axis Y:
   Select the appropriate measurement for the axis X and axis Y from the drop-down list.

10. Click the Ascending  icon to select whether the values on axis X or Y will be sorted in ascending or descending order.

11. Define the Color Axis. Select the measure whose values will determine the color of the cells.

12. If necessary, apply normalization to the data. The values will be shown as percentage, relative to the sum of all the values in the row/column. Set the Relevance Threshold to display only values equal or bigger than the threshold value.

13. (Optional) You can define additional measures – different value for the axis Y:

    1. Click Add Measure and select a measure from the drop-down list.

    2. Specify the value for the Aggregation. The selectable options depend on the data type. For details see Data Calculation Options.

    3. Repeat the process until you have defined all additional readings.

14. Click the Apply and Refresh button or the Refresh icon on the toolbar to update the chart.