Heatmap Reports display your data as the intersection of two metrics in a table with colored cells. These cells contain data values visualized with color brightness.
Image Removed
Image Added
Create a heatmap report
Use Report Designer to create, configure, and style customize heatmap reports.
| Panel |
|---|
| title | To create a bar report, follow the steps below: |
|---|
|
- Navigate to the Reports → Create a ReportNew.
- On the the Data tab tab, fill in the mandatory fields:
- Report name - Name – enter the desired name;
- Table - select Table – select the table you want to use as a source.
- Click Next or the Type tab to continue.
- On the Type tab, click the Heatmap icon of the Multidimensional reports category:
 Image Modified - Click NextNext or the Configure tab.
Fill in the mandatory fields and configure the data, then click Refresh to generate a report. | Note |
|---|
The Report Designer can stop the report generating if there is a large amount of data to display. Use the Condition Builder to limit the data sampling or try another type of report. |
- Customize the style of the report created, and click Refresh.
- Click Click Save.
| Info |
|---|
To open the saved report, navigate to the to Reports → All reports menu Reports and select one from the list. |
|
In the Configure tab, use settings to specify the source datasets to build the desired reportFill in these fields to configure your report in a way you want.
To configure a report, follow the steps below:
- On the Configure tab, specify fill in the report datasetfields.
- Click Refresh to build the report.
- Click Save to save the report.
| Info |
|---|
Use the the Condition Builder to to establish additional conditions for data filtering and grouping.: - Click the icon
 Image Modifiedto open the Condition Builder
, establish your conditions, then click - .
- Set the filters.
- Click Refresh to apply changes.
 Image Removed Image Added
|
| Field | Mandatory | Description |
|---|
| Column |
Row | Set the desired row | column for the heatmap report. |
| Row |
Column | Set the desired | Y | Specify a table column as a |
column | row for the heatmap report. |
| Aggregation |
typeThe data aggregation allows preparing the | Type | N | Select the data aggregation to create combined datasets for data processing |
according to the user needs.Select a type of the data aggregation with one of these Average - counts - Average – counts an average number of the column values.
- Count
|
- counts - – counts a number of entries.
- Count
|
distinct - counts - Distinct – counts the number of unique values of the column.
- Sum
|
- counts - – counts the sum of the numeric data values in this table column.
| Info |
|---|
The Sum and Average settings make sense if the aggregation column keeps the numeric data. |
The aggregation option selected is applied to the table column set in |
the Aggregation column fieldthe Aggregation Column field. |
| Aggregation |
column| Column | Y | Select a table column with numeric values for data aggregation. |
The is the Aggregation type option is not Countthe Aggregation Type option is Average, Count Distinct, Sum. |
|
| Groups |
limit| Limit | N | Set the limit of the data groups shown in your report with a particular number in this field. |
| Show |
rest otherSet on to show the data groups not included in Groups |
limit rest as other is Rest as Other is only available if |
|
the limit Limit option is specified. |
|
Use the the Condition Builder to to establish additional conditions for your report data filtering and grouping.
Customize the style | Anchor |
|---|
| customize the style heatmap report |
|---|
| customize the style heatmap report |
|---|
|
You can configure the report look and heatmap score colors in any way you want with the style settings.
Image Removed
Image Added
To customize a report style, follow the steps below:
- On the Style tab of your report, configure the settings.
- Click Refresh to apply the changes.
- Click Save to save the report.
Change colors, add titles, and customize the data list and table views with the settings below.
The Style tab fields
Style |
|---|
| Field | Mandatory | Description |
|---|
| High |
score colorSet | Score Color | N | Select the color used for high score values of the heatmap chart. Click the magnifier icon  Image Added to select one of the available colors. |
| Low |
score colorSet the color used for low score values of the heatmap chart. |
Drilldown list layout Click the magnifier icon Image Added to select one of the available colors. |
| Drilldown List Layout | N | Use this option to configure the view of the data slice drilled down. Click the magnifier icon |
Image Removed and, in the window appeared,  Image Added to select the desired list view of the source table.
|
| Decimal |
precisionSet the number defining how much numbers should be displayed after the point of numeric data values in your chart. |
| Title Style |
|---|
Report title show type | This field appears when the Aggregation Type field in the Configure tab contains Sum or Average. |
|
| Title |
|---|
| Field | Mandatory | Description |
|---|
| Report Title Show Type | N | Select |
Set the type for the report title showing. |
Select one of the ; only; titleEnter | Specify the title of the report you create. |
| Report |
title sizeEnter | the number of pixels to set the size of the report title. |
| Report |
title color| Title Color | N | Select the color of the report title. Click the magnifier icon Image Added to select one of the available colors. |
| Title |
alignment| Alignment | N | Set the alignment of the chart title selecting one of these options: |
;Left Middle;;;Right Middle;;; boldSwitch on | to make the chart title bold. |
| Legend |
|---|
Style |
|---|
| Field | Mandatory | Description |
|---|
| Show Legend | N |
Set on | to make the chart legend show. |
| Legend |
alignment| Alignment | N | Set the alignment of the chart legend selecting one of these options: |
;Left Middle;;;Right Middle;;; legend borderSet on | to make the border of your chart legend show. |