Skip to content

Chart

SENSE charts bring together a variety of visualization methods and provide a rich set of tools and convenient interactions, helping data professionals to instantly explore, analyze, and process data, and to more efficiently discover hidden information within the data.

This section will introduce the interactions and tools of the SENSE chart interface:

Creating Charts

Within a created dataset, you can select the type of chart you need based on your requirements. According to the requirements of different chart categories, select the dimension and measure fields, and the system will automatically generate the chart. HENGSHI SENSE supports sharing charts and collaborative applications among colleagues. For charts under a specific app, you can use them directly or modify them as needed.

Left Data Panel

Data

Select a created dataset to use its data for creating the required chart. Datasets with established relationships will be connected by lines.

Click the Search icon on the right side of the dataset to go directly to the management page of that dataset.

Fields and Metrics

  • Fields: All original and newly added fields in the current dataset. If a field has grouping information, the grouping will also be displayed in a tree structure in the field list, making it easier to quickly locate fields.

  • Calculated Metrics: All metrics newly added based on this dataset. The grouping information for metrics will also be displayed in the metrics list.

  • In-Chart Metrics: Dimensions and measure fields within the chart.

Drag fields into the Dimensions and Measures sections in the configuration.

Create New Field

You can add text, date, or numeric fields through column value calculation, advanced expressions, or column value grouping.

Create a New Calculated Metric

You can add text, date, or numeric fields through column value calculation, advanced expressions, or column value grouping. Adding non-aggregated metrics is not allowed.

Create Parameter

You can add parameters of text, number, date, or time types to enable parameterized control of the app.

Top Right Toolbar

For details, see Common Chart Operations

Middle Toolbar

Switch Chart

Users can switch between different chart types as needed. Colored icons allow direct switching without the need for reconfiguration. When switching to a gray icon, the chart's dimensions and measures will not be retained, and users will need to reconfigure the measures and dimensions themselves.

Configuration

Select Configuration from the middle navigation bar to make the following configurations as needed to optimize the complete chart.

  • Dimension
  • Measure
  • Filter

Dimension Tools

Dimension tools include:

  • Rename: Modify the dimension name to make the chart content more relevant to the business scenario.
  • Display Format
  • Sorting
  • Calculation: Dimension aggregation method.
  • Edit as Expression
  • Merge Items: Merge items with a very small proportion.
  • Fill Time Points: When selecting a time dimension, the option to fill time points will appear.
  • Delete: Remove the current dimension.
Display Format

The display format for numeric types is as follows. You can customize the number display format:

  • Use dataset field display format: Displays according to the field display format set in the dataset.
  • Decimal places: By default, 2 decimal places are shown. You can customize the number of decimal places.
  • Number unit: By default, no unit is displayed. You can customize the number unit: Auto, Hundred Million, Ten Million, Million, Ten Thousand, Thousand, Hundred, M, K.
  • Prefix/Suffix: By default, none is displayed. You can customize the prefix/suffix.
  • NULL value display: Replace NULL values with specified content for display.
  • Empty value display: Replace empty values with specified content for display.
  • Show thousands separator: Not selected by default. Users can customize according to their needs.
  • Show percentage: Not selected by default. Users can customize according to their needs.
  • Always show "+" for positive numbers
  • Pad decimal places
  • Show scientific notation: Not selected by default. Users can customize according to their needs.

The display format for date types is as follows. You can customize the date display format:

Sorting

Dimension sorting options include: data source sorting, alphabetical, by field, and manual sorting.

Click the dropdown menu on the right side of the dimension field, and select "Sort" from the pop-up menu.

  • Sort by This Dimension: Sorts based on the Unicode values of this dimension.

  • Sort by Pinyin: Sorts the dimension in A-Z order according to Pinyin; currently, alphabetical sorting is supported for the following six types: Oracle, MySQL, Sqlserver, PostgreSQL, GreenPlum, and Engine.

Date and numeric type dimension fields do not support alphabetical sorting.

  • Sort by Specified Field: You can select a field from the same dataset or a related dataset, specify an aggregation method, and sort the dimension based on the aggregated results.

  • Sort by Measure in Chart: You can select a measure field from the same chart and sort the dimension based on the aggregated results of the measure field.

  • Manual Sorting: You can manually adjust the order of dimension groups.

Calculation

The aggregation method for non-time dimensions is grouping, while the aggregation methods for time dimensions are:

  • Millisecond
  • Second
  • Minute
  • Hour
  • Day
  • Day (across weeks)
  • Day (across months)
  • Week
  • Month
  • Month (across years)
  • Quarter
  • Quarter (across years)
  • Year
Merge Items

Charts with dimensions (except maps) support merging items into "Others". When focusing only on items with a higher proportion during grouped data display, items with a smaller proportion can be merged into "Others", making the displayed chart more concise and clear.

The merged group also supports operations such as drill-down, view details, and linked filtering.

Time Point Completion

Currently, the following chart types support time point completion:

  • Line Chart
  • Grouped Line Chart
  • Line and Bar Combo Chart
  • Area Chart
  • Grouped Area Chart
  • Stacked Area Chart
  • Stream Area Chart
  • Grouped Stacked Area Chart
  • 100% Stacked Area Chart
  • 100% Grouped Stacked Area Chart

Charts with time point completion are shown below:

Metric Tools

Metric tools include:

  • Rename: Modify the metric name to make the chart content more relevant to the business scenario.
  • Display Format
  • Calculation: Metric aggregation method.
  • Delete: Remove the current metric.
Display Format

Non-date fields are displayed in numeric format; date fields are displayed in date format.

Calculation

Aggregation methods for numeric metrics include:

  • Sum
  • Average
  • Minimum
  • Maximum
  • Percentile
  • Count
  • Distinct
  • Duplicate
  • Retention
  • Active

Aggregation methods for non-numeric metrics include:

  • Count
  • Distinct
  • Duplicate
  • Retention
  • Active

Filter

Drag fields from the Fields and Metrics section on the left into the Configuration -> Filter area of the chart to add filter conditions to the chart.

Fields and Metrics include Raw Fields, In-Chart Metrics, and Calculated Metrics, which are categorized by field type. You can select and add filter conditions as needed.

  • For text type fields, you can choose Exclude/Include for filtering.
  • For numeric type fields, you can choose Range/Comparison for filtering.
  • For date type fields, you can choose Time Period/By Year/By Quarter/By Month/Range for filtering.
  • For all types, you can also enter expressions in the Expression field for filtering. Supported Functions for Expressions

Tip

Filter expressions do not allow mixing aggregate and non-aggregate expressions.

Drag fields into Configuration -> Filter:

Text type field filtering:

Numeric type field filtering:

Date type field filtering:

Expression filtering:

You can choose whether to display filter information during filtering

If you choose to display filter information, the filter conditions will be shown below the chart name

Style

Style includes the following sections:

  • Title
  • Chart Content
  • Shadow
  • X Axis
  • Y Axis
  • Legend
  • Reference Line
  • Padding

Title

You can customize the name of the chart.

Status Icon

You can set the display status of icons on charts within the dashboard, supporting both hover display and fixed display.

Annotation

  • Chart annotation: Rich text, editable as needed
  • Field annotation: Notes and business meaning of field metrics defined in the dataset

Chart Content

Chart content includes the following sections:

  • Color: You can change the chart color scheme. You can select a predefined color palette or customize the color for each dimension group individually.

At the bottom of the color settings, there is a Show Gradient toggle switch. For all non-gradient color bar charts and area charts, you can enable gradient coloring.

  • Size: You can adjust the chart size.

  • Label: Chart labels can display metric values, dimension groups, and other information. You can modify the label's font, color, weight, text angle, position, and offset.

  • Tooltip: Tooltips can display metric values and dimension groups. You can modify the tooltip's font, color, weight, border color, border thickness, shape, background color, and more.

Shadow

Only charts under the Bar Group can have shadows enabled. Click Style -> Shadow to set whether to display the shadow and to configure the shadow color.

X-Axis

You can adjust the font color, size, text angle, axis style, and choose to display the axis and tick labels.

Y Axis

You can adjust the font color, size, text angle, axis style, display the axis and tick labels, adjust the tick range, and tick lines.

Display Legend

You can choose whether to display the legend and set its position to the left, right, or top. You can also modify the legend's font, color, size, and whether it is bold.

Supports displaying "Select All" and "Deselect All" options. When the display toggle is enabled and the number of legends is greater than or equal to the set auto-display rule, the "Select All" and "Deselect All" buttons will be shown.

Reference Line

For more details, see Reference Line.

Padding

Padding can control the position of the chart within the entire page.

Interaction

Interaction includes the following sections:

  • Limit Rows
  • Auto Refresh
  • Value Range Roaming
  • Time Roaming
  • Click Interaction Behavior in Chart
  • Drill-down Settings

Limit Number of Rows

Users can set the number of data rows displayed in the chart via Interaction -> Limit Number of Rows, with a default value of 1000 rows.

Please note

Setting this value too high may slow down both the database and the browser.

Auto Refresh

Similar to the Refresh feature of dashboards, the auto refresh function allows chart data to be updated automatically at regular intervals. After enabling the auto refresh feature, you can set the update interval, and the auto refresh time value supports customization.

Charts with auto refresh enabled will also refresh automatically within dashboards.

If a data analyst wants to create a dashboard where charts dynamically update based on real-time data—displaying dynamic effects like an electrocardiogram on a large screen—they can enable the Auto Refresh -> Incremental Update feature.

Supported chart types for incremental updates: Gauge, all Bar chart types, all Donut chart types, all Line/Area chart types, all Relationship chart types, Simple Map, and Combo chart.

Data Zoom

When Data Zoom is enabled, a slider will appear on the dimension axis, allowing you to adjust the currently displayed dimensions by dragging the slider. Each dimension will be proportionally re-displayed in the chart. As shown in the figure, the gray scroll bar below the dimension axis:

When some charts have a large number of data groups (such as bar charts), but you do not want to display all groups by default, you can configure the default display range for Data Zoom. There are four options available: "All", "First M Groups", "Last N Groups", and "Custom", which can meet various configuration scenarios.

Time Roaming

Enable Show Time Roaming, and drag the time field from your dataset into the box. This will display a timeline on the chart interface, allowing you to easily drag and view data for different time ranges. The timeline can filter data in three ways:

  • Drag the timeline to filter data

  • Select a built-in time period to filter data

  • Select a custom time range to filter data

    • You can set a time range

    • You can drag the timeline to conveniently change the selected area

    • You can select a time period

      • All valid times
      • This year
      • This quarter
      • Last 90 days
      • This month
      • Last 30 days
      • This week
      • Last 7 days
      • Yesterday
      • Today
      • This hour

Click Interaction Behavior in Charts

For chart types that support drill-down and exclusion, see Appendix: Chart Type Summary. You can set three display modes for clicking on dimension groups:

  • No Response
  • Pop-up Menu
  • Drill-down

No Response

When you open the chart and click on the chart area, there is no response.

Context Menu

Open the chart and click on the chart area. In the pop-up Tooltip menu, there are three actions: Drill Down, Exclude, and Details.

Drill Down

In charts that support drill down, click on a specific dimension in the chart and select Drill Down in the pop-up Tooltip. If a drill down path has been set, the chart will use the selected dimension as a filter and redraw the chart with the newly selected field as the dimension. You can drill down continuously. If no drill down path has been set, the drill down option will not be clickable.

Exclude

Click on a dimension in the chart, and select Exclude in the pop-up Tooltip. The chart will exclude the selected dimension group and display the remaining dimension groups.

Details

Click on a dimension in the chart, select Details in the pop-up Tooltip, and a new window will display the detailed data for the selected dimension group.

Drill Down

If a drill-down path is set, when you open the chart and click on the chart area, the chart will be redrawn using the selected dimension as a filter and the newly selected field as the dimension. If no drill-down path is set, there will be no response.

Drill Down Settings

In charts that support drill down, select a field and drag it into Interaction -> Drill Down Settings. Click on a dimension in the chart, and in the pop-up Tooltip menu, click Drill Down. The chart will use the selected dimension as a filter and redraw the chart with the newly selected field as the dimension. You can drill down continuously.

Drill down is only a temporary action and does not change the original dimensions of the chart. When you exit and reopen the chart, it will return to its original state.

You can also restore the chart by clicking the first field in the drill down path.

Setting the Chart After Drill-Down

You can configure this in both the Configuration and Style sections, just like with other charts.

Appendix: Chart Types Summary

  • For each type of chart 📈—pie chart, line chart, scatter plot, area chart, bar chart, etc.—different fields for dimensions usually need to be configured, along with sort/limit options, filters, and more. The unified summary is as follows:
Chart TypeNumber of DimensionsNumber of MeasuresDimension SortingDrill DownLegendLegend InteractionChart LabelsLinked FilteringReference LineScale Range SettingExclude
Bar Chart11Data Source/Alphabetical/Field/Manual SortingAllowedDefault measure rangeNoneMeasure ValueDimension GroupingFixed/Calculated ValueAllowedDimension Grouping
Clustered Bar Chart11~NData Source/Alphabetical/Field/Manual SortingAllowedEach measureSingle/Multiple SelectionMeasure ValueDimension GroupingFixed/Calculated ValueAllowedDimension Grouping
Grouped Clustered Bar Chart21Data Source/Alphabetical/Field/Manual SortingAllowedSub-dimension groupsSingle/Multiple SelectionMeasure ValuePrimary Dimension GroupingFixed/Calculated ValueAllowedPrimary Dimension Grouping
Grouped Stacked Bar Chart21Data Source/Alphabetical/Field/Manual SortingAllowedSub-dimension groupsSingle/Multiple SelectionMeasure ValuePrimary Dimension GroupingFixed/Calculated ValueAllowedPrimary Dimension Grouping
Percentage Grouped Stacked Bar Chart21Data Source/Alphabetical/Field/Manual SortingAllowedSub-dimension groupsSingle/Multiple SelectionMeasure ValuePrimary Dimension GroupingFixed/Calculated ValueAllowedPrimary Dimension Grouping
Horizontal Bar Chart11Data Source/Alphabetical/Field/Manual SortingAllowedMeasure rangeNoneMeasure ValueDimension GroupingFixed/Calculated ValueAllowedDimension Grouping
Horizontal Clustered Bar Chart11~NData Source/Alphabetical/Field/Manual SortingAllowedEach measureSingle/Multiple SelectionMeasure ValueDimension GroupingFixed/Calculated ValueAllowedDimension Grouping
Horizontal Stacked Bar Chart11~NData Source/Alphabetical/Field/Manual SortingAllowedEach measureSingle/Multiple SelectionMeasure ValueDimension GroupingFixed/Calculated ValueAllowedDimension Grouping
Horizontal Percentage Stacked Bar Chart11~NData Source/Alphabetical/Field/Manual SortingAllowedEach measureSingle/Multiple SelectionMeasure ValueDimension GroupingFixed/Calculated ValueAllowedDimension Grouping
Ring Bar Chart11NoneAllowedDimension groupsSingle/Multiple SelectionMeasure ValueDimension GroupingNot SupportedAllowedDimension Grouping
Stacked Bar Chart11~NData Source/Alphabetical/Field/Manual SortingAllowedEach measureSingle/Multiple SelectionMeasure ValueDimension GroupingFixed/Calculated ValueAllowedDimension Grouping
Percentage Stacked Bar Chart11~NData Source/Alphabetical/Field/Manual SortingAllowedEach measureSingle/Multiple SelectionMeasure ValueDimension GroupingFixed/Calculated ValueAllowedDimension Grouping
Box Plot11Data Source/Alphabetical/Field/Manual SortingAllowedDimension groupsSingle/Multiple SelectionNoneDimension GroupingNoneAllowedDimension Grouping
Waterfall Chart11Data Source/Alphabetical/Field/Manual SortingAllowedIncrease/DecreaseSingle/Multiple SelectionMeasure ValueDimension GroupingFixed ValueNot AllowedDimension Grouping
Word Cloud11NoneAllowedMeasure rangeNoneNoneDimension GroupingNoneNot AllowedDimension Grouping
Donut Chart11Data Source/Alphabetical/Field/Manual SortingAllowedDimension groupsSingle/Multiple SelectionDimension Group PercentageDimension GroupingNoneNot AllowedDimension Grouping
Funnel Chart11Data Source/Alphabetical/Field/Manual SortingAllowedDimension groupsSingle/Multiple SelectionDimension Group/Measure Value/Conversion Rate Between GroupsDimension GroupingNoneNot AllowedDimension Grouping
Bubble Chart1~N1NoneAllowedMeasure rangeNoneDimension Group/Group ProportionCombination of Dimension GroupsNoneNot AllowedCombination of Dimension Groups
Pie Chart11Data Source/Alphabetical/Field/Manual SortingAllowedDimension groupsSingle/Multiple SelectionDimension Group PercentageDimension GroupingNoneNot AllowedDimension Grouping
Nightingale Rose Chart11Data Source/Alphabetical/Field/Manual SortingAllowedDimension groupsSingle/Multiple SelectionDimension Group PercentageDimension GroupingNoneNot AllowedDimension Grouping
Sunburst Chart1~N1NoneAllowedNoneSingle/Multiple SelectionGroups of Each DimensionCombination of Dimension GroupsNoneNot AllowedCombination of Dimension Groups
Treemap1~N1NoneAllowedMeasure rangeNoneDimension GroupCombination of Dimension GroupsNoneNot AllowedCombination of Dimension Groups
Area Chart11~NData Source/Alphabetical/Field/Manual SortingAllowedEach measureSingle/Multiple SelectionMeasure ValueDimension GroupingFixed/Calculated ValueAllowedDimension Grouping
Grouped Area Chart21Data Source/Alphabetical/Field/Manual SortingAllowedSub-dimension groupsSingle/Multiple SelectionNonePrimary Dimension GroupingFixed/Calculated ValueAllowedPrimary Dimension Grouping
Grouped Stacked Area Chart21Data Source/Alphabetical/Field/Manual SortingAllowedSub-dimension groupsSingle/Multiple SelectionMeasure ValuePrimary Dimension GroupingFixed/Calculated ValueAllowedPrimary Dimension Grouping
Percentage Grouped Stacked Area Chart21Data Source/Alphabetical/Field/Manual SortingAllowedSub-dimension groupsSingle/Multiple SelectionMeasure ValuePrimary Dimension GroupingFixed/Calculated ValueAllowedPrimary Dimension Grouping
Stacked Area Chart11~NData Source/Alphabetical/Field/Manual SortingAllowedEach measureSingle/Multiple SelectionNoneDimension GroupingFixed ValueNot AllowedDimension Grouping
Percentage Stacked Area Chart11~NData Source/Alphabetical/Field/Manual SortingAllowedEach measureSingle/Multiple SelectionNoneDimension GroupingFixed ValueNot AllowedDimension Grouping
Line Chart11~NData Source/Alphabetical/Field/Manual SortingAllowedEach measureSingle/Multiple SelectionMeasure ValueDimension GroupingFixed/Calculated ValueAllowedDimension Grouping
Combo Line-Bar Chart11~NData Source/Alphabetical/Field/Manual SortingAllowedEach measureSingle/Multiple SelectionMeasure ValueDimension GroupingFixed/Calculated ValueAllowedDimension Grouping
Grouped Line Chart21Data Source/Alphabetical/Field/Manual SortingAllowedSub-dimension groupsSingle/Multiple SelectionMeasure ValuePrimary Dimension GroupingFixed/Calculated ValueAllowedPrimary Dimension Grouping
Pareto Chart11NoneAllowedFrequency/Cumulative FrequencySingle/Multiple SelectionMeasure ValueDimension GroupingFixed/Calculated ValueNot AllowedDimension Grouping
Arc Relationship Chart20Data Source/Alphabetical/Field/Manual SortingAllowedSub-dimension groupsNoneNoneNoneNoneNot AllowedNone
Chord Diagram21Data Source/Alphabetical/Field/Manual SortingAllowedGroups of Each DimensionHover OnlyGroups of Each DimensionNoneNoneNot AllowedNone
Heatmap21Data Source/Alphabetical/Field/Manual SortingAllowedMeasure rangeNoneMeasure ValueCombination of Dimension GroupsNoneNot AllowedCombination of Dimension Groups
Radar Chart11~NData Source/Alphabetical/Field/Manual SortingAllowedEach measureSingle/Multiple SelectionDimension Group/Measure ValueDimension GroupingNoneAllowedNone
Sankey Diagram1~N1Data Source/Alphabetical/Field/Manual SortingAllowedNoneNoneGroups of Each DimensionNoneNoneNot AllowedNone
Scatter Plot13NoneAllowedSize measure rangeNoneDimension GroupsDimension GroupingFixed/Calculated ValueAllowed (setting only, not merging)Dimension Grouping
Gauge02NoneNot AllowedNoneNoneName/Number/Percentage of Proportion MeasureNoneFixed ValueNot AllowedNone
KPI01~NNoneNot AllowedNoneNoneNoneNoneNoneNot AllowedNone
Metric Trend Card11~NNoneNot AllowedNoneNoneNoneNoneNoneNot AllowedNone
Table0~N0~NData Source/Alphabetical/Field/Manual SortingNot AllowedNoneNoneNoneNoneNoneNot AllowedNone

User Manual for Hengshi Analysis Platform