Time Axis

Application Scenario

Axes in some charts are categorized by date format such as year, month, and day, and you want data in charts to be displayed according to the date value from smallest to largest.

Also, you want to set the unit of data display, for example, you can display the data by year or by month, as shown in the following figure.

Note:

Time Axis is only suitable for column charts, line charts, bar charts, area charts, and combination charts.

Implementation Method

Set the style of the axis. Choose Cell Element > Style > Axis, and select Time Axis from the drop-down list of Type.

Set the format of the axis label. Choose Cell Element > Style > Axis, and select Date from the drop-down list of Axis Label Format.

Data Preparation

Create a general report and add a dataset named ds1. The SQL statement is SELECT * FROM Sales_Volume.

Report Design

1. Merge required cells, click Cell Element, select Insert Chart from the drop-down list of Insert Element, and select Column Chart for Type, as shown in the following figure.

2. Choose Cell Element > Data, and bind the data to the column chart, as shown in the following figure.

3. Select the chart, choose Cell Element > Style > Axis > X Axis, and set Type and Axis Label Format respectively, as shown in the following figure.

4. Choose Cell Element > Style > Axis > X Axis, and customize Minimum Value, Maximum Value, and Main Unit, as shown in the following figure. 

Effect Display

PC

Save the template and click Pagination Preview. The section "Application Scenario" shows the effect.

Mobile Terminal

The report can be previewed on both the DataAnalyst app and the HTML5 terminal. The following figure shows the effect. 

 For details, you can download the template Time Axis.cpt