Year-Round Calendar Heatmap

Application Scenario

The calendar heatmap is a type of time series chart that combines a heatmap and a calendar chart. The calendar heatmap is a bivariate chart consisting of a time variable and another variable. The calendar heatmap can reflect the value distribution in a certain period, helping analysts compare and analyze certain data over different time spans.

You can use the calendar heatmap in the following scenarios.

• You want to display the number of steps taken each day this year, with different color shades indicating the number of steps taken on each day.

• You want to show the air quality of a city by displaying the city's daily PM2.5 data this year.

The following figure shows the effect.

Basic Requirement

The following section describes the basic requirements for the calendar heatmap.

1. The dimension field must be equal to or greater than 1 and must be in a complete date format.

2. The date data must be continuous, otherwise the calendar heatmap cannot be arranged in order.

Chart Feature

Advantage: The calendar heatmap effectively combines the heatmap and the calendar chart, clearly presenting the indicator changing with the calendar.

Disadvantage: The calendar heatmap is only suitable for displaying changes in one or two indicators.

Data Preparation

1. Log in to the system as the admin, click My Analysis, click a folder, and click New Subject.

2. Click Local Excel and click Upload Data, as shown in the following figure.

You can download the sample data: Thermal Power Data.xlsx.

3. After the upload, click OK.

Component Creation

1. Create a component, click the Custom Chart icon in Chart Type, and drag the Date field into Horizontal Axis.

2. Hover the cursor over the Date field in Horizontal Axis, click the drop-down icon, and choose More Groups > Day.

3. Drag the Date field into Vertical Axis, hover the cursor over the field, click the drop-down icon, and choose More Groups > Month.

4. Select Rectangular Block in Graphic Property.

5. Choose Component Style > Adaptation Display and select Overall Adaptation.

Component Beautifying

Setting the Label

Drag the Date field into Label, hover the cursor over the field, click the drop-down icon, and choose More Groups > Day.

Setting the Color

Drag the FDL_DR field into Color, click Color, and select the Future gradient solution.

Setting the Style

Choose Component Style > Legend and deselect Display All Legends.

Renaming Fields on the Horizontal and Vertical Axes

Double-click the fields on the horizontal and vertical axes, and rename them Day and Month respectively.

Dashboard Adding

Create a dashboard and add the component to the dashboard.

Effect Display

On PC

The following figure shows the preview effect on PC.

On Mobile Terminals

The following figure shows the preview effect on the DataAnalyst app and in HTML5.

Drag the Date field into Vertical Axis and group the field by year based on the above example.

Then the data is grouped by year.

The following figure shows the effect of dragging multiple fields into Horizontal Axis.

Notes:

If you want the dates in the calendar to be arranged in order of week, you need to set Week Start From to Monday by choosing System Management > System Setting > General and then restart the project.