Is this helpful?

# Visualization Module

The visualization module of TE provides an array of data processing and presentation capacities. You may use the visualization module to add interactive charts to query results and save them as reports that can be viewed from dashboards.

Presently, the visualization module is only provided by the SQL query module.

# Add visualized charts

Click "New Chart" on the SQL query page to access the visualization configuration page.

# Configure chart field

After selecting the chart type, drag and drop the result field under the "Data" tab to dimension or metric configuration area in order to view the display effect of the chart.

Different configuration items correspond to different mapping logics. Take the line and scatter plots, for instance. The mapping logic for the fields are as follows:

Chart Type Configuration item Mapping description
Line chart X-Axis/ Dim. Mapped to x-axis
Colour/ Dim. Mapped to colour legend
Y-Axis/ Metric Mapped to metric value
Scatter diagram X-Axis Mapped to coordinate points on x-axis, taking numerical value
Y-Axis Mapped to coordinate points on x-axis, taking numerical value
Groups Mapped to point information
Colour Mapped to point color
Size Mapped to point size

You may select an aggregation type for metric field depending on specific scenario. The aggregation modes for different field types are as follows:

Field type Aggregation mode
Number sum, average, count, count distinct, maximum, minimum
Date/String/Boolean count, count distinct

In addition, you may also set the display format for the data of a metric field:

  • By default, data is shown with a thousandth with two decimals.
  • You may customize decimal places, quantity units and whether to enable thousandth (a maximum of 10 decimal places are allowed, and trailing zeros to the right of the decimal point are not displayed).

# Chart formatting

You may modify the display detail of charts from the "Formatting" tab. Different type configurations are supported for different charts.

The configuration items for line charts, for example, are as follows:

  • Display Setting: Configure how many first entries of data are displayed in x-axis and colour legends fields of the current chart.
  • Axis: Configure whether to display axis tags and the display mode of axis tags.
  • Metrics: Configure whether to display labels, as well as maximum and minimum values, on a chart.
  • Groups: Configure whether to show the day of the week in the date field.

# Visualization analysis

# Sort by field

The sort-by-field feature supports sort by dimension field and by metric field.

  • Modes supported by sort-by-dim
    • Unsort
    • Ascending order
    • Descending order
    • Sort by metric value
      • For example, in the following descending order of channel fields by the total sum of top-up, the channel having the most top-up amounts will be displayed in a prioritized manner.

  • Sort by metrics

    • Sort by table metrics
      • Ascending order, descending order and unorder can be set for specified metric.
  • Metric order for line/ bar / stacked bar charts.

    • Logic of order: Order X-axis/dim fields by metric values, and when there exists colour/ dim fields, order these fields by their metric values.
    • Case: As shown in the following figure, the total top-up is sort in a descending order:
      • "date" is sorted in a descending order by total top-up
      • "channel" is sorted in a descending order by total top-up

# Filters

The In-chart filter performs filtering operations in order to display data that users want to focus on. You can drag and drop any field from the query results to the in-chart filter; or click the drop down arrow on the right side of the metric to add the metric into the filter.

Add in-chart filter and save the report, and after putting it into the dashboard, you will be able to perform filtering operation when viewing the dashboard.

# Computational logic

# Compute using full data

On the configuration page, when SQL query results exceed the upper limit of returns (20,000 entries by default), only computational results of returned data across visualization configurations will be displayed in order to avoid repeated loading of computation in the process of visualization configuration that leads to performance problems.

If you want to view computational results of all data on the visualization configuration page, you can click "Calculate with full data" on the lower left corner.


This item is provided mainly to address the performance experience problem arising from repeated loading and computation during visualization configuration. When viewing results on report page or dashboard, the results will be computed and displayed based on full data.

In addition, if the number of query results of the model exceeds the upper limit, re-computation based on full data will also be initiated when sorting or filtering operation is performed on the report page or dashboard in order to ensure the validity of results.