Chart components include trend analysis line chart, stacked area chart, cumulative chart; comparison analysis bar chart, stacked bar chart, percentage bar chart; distribution pie chart, word cloud chart; relationship analysis funnel chart, as well as metric card and dashboard chart that display metric status. Specifically as follows:
Line Chart
A line chart is a statistical chart composed of points and lines, used to analyze the trend of things changing with time or ordered categories. It can also be used to analyze the interaction and influence between multiple sets of data changing with time or ordered categories.
Data Configuration
After dragging the fields in the numerical and dimensional areas to the corresponding configuration areas, the chart preview area on the right will automatically render,The data configuration of a Line chart requires one continuous time field or one classification field (dimension) and at least one continuous data field (indicator).Please refer to the following figure for details:
Serial Number | Function | Description |
---|---|---|
1 | Data Configuration Area | Configuring the summary mode of dimensions/metrics in the field parsing area, where sub-dimensions can supplement the main dimension. |
2 | Field Settings Area | Indicators can be summed, averaged, counted, maximum, minimum, median, and standard deviation. For details, please refer to: Data Processing and Processing |
3 | Field Parsing Area | Place all fields in the table in the field parsing area, and drag the fields into the data configuration area for data calculation |
Style Configuration
Metric and Dimension Display Configuration
- Metric Display Configuration. After configuring multiple metrics in the line chart, you can choose the position of each metric on the left or right Y-axis. The line chart style can be solid or dashed.
- Dimension Display Configuration, limiting the number of groups displayed under the dimension. The displayed quantity needs to be an integer between 1 and 1000, as shown in the figure below:
Axis Configuration
The line chart can display titles for both the horizontal and vertical axes, and supports custom modifications for axis titles. The Y-axis of the line chart supports custom axis intervals, making the vertical coordinate line better highlight the actual business fluctuations, as shown in the figure below:
Stacked Area Chart
The stacked area chart is used to display the trend of multiple category data with time or other continuous variables, and compare the proportion relationship between each category data.
Data Configuration
Drag the field from the value area or dimension area to the corresponding configuration area, and the chart preview area on the right will be automatically rendered. The data configuration of the stacked area chart requires a continuous time field or a categorical field (dimension) and at least one continuous data field (metric).See the figure below for details:
Number | Function | Description |
---|---|---|
1 | Visualization component preview area | The overall area can be previewed with visual components, and the report name defaults to "New Report {Number}", which can be customized and modified at will |
2 | Data Configuration Area | The summary mode of dimensions/metrics in the field configuration area, where the sub-dimensions can supplement the main dimensions |
3 | Field Configuration Area | Metrics can be summed, averaged, counted, found the maximum, minimum, median, standard deviation, please refer to: Data Processing and Processing |
4 | Field Parsing Area | All the fields from the table in the field parsing area, drag the fields into the data configuration area for data calculation |
Style Configuration
Display configuration for metrics and dimensions
- Display configuration for metrics. After configuring multiple metrics in the stacked area chart, you can choose the left and right Y-axis positions for each metric separately, and you can also choose whether to display data labels
- Display configuration for dimensions, limiting the number of groups displayed under dimensions. The display quantity needs to be an integer within the range of 1 to 1000, as shown in the figure below:
Axis Configuration
Both the horizontal and vertical axes in the stacked area chart can display axis titles and support custom modifications. The Y-axis supports custom axis intervals, making the vertical axis line better highlight the actual business fluctuations, as shown in the figure below:
Cumulative Chart
The cumulative chart displays the cumulative change of total quantities of multiple category data over time, and compares the differences between different category data.
Data Configuration
After dragging the numeric and dimension fields to the corresponding configuration area, the preview area on the right will automatically render the accumulated chart. The data configuration of the accumulated chart requires a continuous time field or a categorical field (dimension) and at least one continuous data field (metric), see the figure below:
Number | Function | Description |
---|---|---|
1 | Visualization component preview area | The overall area can be used for previewing visualization components. The default report name is "New Report {number}" and can be customized. |
2 | Data configuration area | Configure the summarization mode of dimensions/metrics for the field parsing area, where sub-dimensions can be used as supplements to the main dimension. |
3 | Field settings area | Metrics can be summed, averaged, counted, maximized, minimized, median, standard deviation, etc. See: Data Processing and Processing |
4 | Field parsing area | Place all fields in the table in the field parsing area, and drag the fields into the data configuration area for data calculation |
Style Configuration
Display configuration of indicators and dimensions
- Indicator display configuration. After configuring multiple indicators in the cumulative graph, you can choose the left and right Y-axis positions displayed for each indicator separately, and you can choose the number of label intervals to display data labels. It supports switching between virtual and real lines
- Dimension display configuration, which limits the number of grouped displays under a dimension. The display quantity must be an integer between 1 and 1000, as shown in the following figure:
Coordinate Axis Configuration
The horizontal and vertical axes of the cumulative graph can display axis titles, and support customized modification of axis titles, as well as the selection of display abbreviate axis, as shown in the following figure:
Bar Chart
The bar chart consists of a set of vertical or horizontal rectangular columns, the height or length of each column represents the quantity or proportion of corresponding data,Commonly used to compare data between different groups and categories
data configuration
After dragging the fields in the value area and dimension area to the corresponding configuration area, the chart preview area on the right will automatically render. The data configuration of the Line chart requires a classification field (dimension) and at least one data field (indicator), as shown in the following figure:
Index | function | Description |
---|---|---|
1 | Visualization component preview area | The overall area can be used for previewing visualization components. The report name is set as "New Report{number}" by default, but can be customized. |
2 | Data configuration area | Configuring the summary mode of each field in the field parsing area, where the subdivision dimension can be used as a supplement to the main dimension |
3 | Field configuration area | The metrics can be summed, averaged, counted, get the maximum, get the minimum, get the median, get the standard deviation, etc. For more details, please refer to: Data Processing and Processing. |
4 | Field parsing area | Place all fields in the field parsing area of the table, and drag the fields into the data configuration area for data calculation |
Style configuration
Dimension and metric display configuration
- Metric display configuration. After configuring multiple metrics in a bar chart, you can choose the position of the left or right Y-axis for each metric to be displayed. The style of the bars can be set as opaque or transparent
- Dimension display configuration, limiting the number of groups to display under the dimension. The display quantity should be an integer between 1 and 1000, as shown in the following figure:
Axis Configuration
Both horizontal and vertical axes of bar charts can display axis titles, and support custom modification of axis titles. The Y-axis of bar charts supports custom axis intervals, which can better highlight the actual business fluctuations of the bars, as shown in the following figure:
Stacked Bar Chart
Stacked bar charts can visually display the values of sub-groups within a large group, reflecting the relationship between local data and the whole
Data Configuration
After dragging the fields in the numerical and dimensional areas to the corresponding configuration areas, the preview area of the chart on the right will automatically render and stack the column chart configurationSelect at least two dimensions on the X-axis and at least one indicator on the Y-axis, as shown in the following figure:
Index | Function | Description |
---|---|---|
1 | Visualization Component Preview Area | The overall area can be used for previewing the visualization components. The default report name is "New Report {Number}", which can be customized as desired. |
2 | Data Configuration Area | Configure the aggregation mode of dimensions/metrics in the field parsing area, where subdivision dimensions can complement the main dimensions |
3 | Field Setting Area | Indicators can be summed, averaged, counted, maximum, minimum, median, standard deviation, etc. Please refer to:Data Processing and Processing |
4 | Field parsing area | Place all fields in the table in the field parsing area, and drag the fields into the data configuration area for data calculation |
Style Configuration
Dimension Indicator Display Configuration
The data labels on the coordinate axis of the stacked bar chart can be displayed with optional individual configurations and global intelligence, as shown in the following figure:
Index | function | Description |
---|---|---|
1 | Label display | Global intelligence is the adaptive display of the actual stacking area of stacked bar charts; Setting it separately displays a separate style for a single indicator |
2 | Display number | Limit the number of dimensions and sub dimensions displayed in the chart |
3 | Legend Item | Choose the position of the legend item, default is bottom |
Axis Configuration
Both the horizontal and vertical axes of the stacked bar chart can display axis titles, and support custom modification of axis titles. The Y-axis of the bar chart supports custom axis intervals, so that the height and depth of the bars can better highlight the actual business fluctuations, as shown below:
Percentage Stacked Bar Chart
The percentage stacked bar chart displays the proportions of different subgroups within a large group, reflecting the relationship between local data and the whole.
Data Configuration
After dragging the fields in the numerical and dimension areas to the corresponding configuration areas, the preview area of the chart on the right will automatically render, and the percentage stacked column chart will be configured. Select at least two dimensions on the X-axis and at least one indicator on the Y-axis, as shown in the following figure:
Index | Function | Description |
---|---|---|
1 | Visualization Component Preview Area | The overall area can be used for visualization component preview. The report name is default to "New Report {number}", and can be customized. |
2 | Data configuration area | Configure a summary mode for the dimensions/indicators of each field in the field analysis area, where the subdivision dimension can serve as a supplement to the main dimension |
3 | Field Setting Area | Indicators can be summed, averaged, counted, maximum, minimum, median, standard deviation, etc. Please refer to:Data Processing and Processing |
4 | Field parsing area | Place all fields in the table in the field parsing area, and drag the fields into the data configuration area for data calculation |
Style Configuration
Dimension Indicator Display Configuration
Index | Function | Description |
---|---|---|
1 | Label display | Global intelligence is the adaptive display of the actual stacking area of stacked bar charts; Setting it separately displays a separate style for a single indicator |
2 | Display Quantity | Restrict the display quantity of dimensions and sub-dimensions in the chart |
3 | Legend Item | Choose the position of the legend item, default is below |
Axis Configuration
Both the horizontal and vertical axes of the stacked bar chart can display axis titles, and support custom modification of axis titles. They also support the selection of abbreviate axis, as shown in the figure below:
Line and Bar Combination Chart(Combo Chart)
Each metric in the line and bar combination chart can be shown as a line or bar chart. It is used to display the numerical trend changes of different metrics over a period of time. It supports the display of different data magnitudes on the left and right dual axes.
Data Configuration
After dragging the fields in the value area and dimension area to the corresponding configuration area, the preview area on the right will be automatically rendered. The line and bar combination chart should select at least one dimension on the X-axis and multiple metrics on the Y-axis, as shown in the figure below:
Index | Function | Description |
---|---|---|
1 | Visualization Component Preview Area | The overall area can be previewed with visual components, and the report name defaults to "New Report {Number}", which can be customized and modified at will |
2 | Data configuration area | Configure a summary mode for the dimensions/indicators of each field in the field analysis area, where the subdivision dimension can serve as a supplement to the main dimension |
3 | Field Setting Area | Indicators can be summed, averaged, counted, maximum, minimum, median, standard deviation, etc. Please refer to:Data Processing and Processing |
4 | Field parsing area | Place all fields in the table in the field parsing area, and drag the fields into the data configuration area for data calculation |
Style Configuration
Dimension Indicator Display Configuration
- Indicator display configuration. After configuring multiple indicators in the online column combination chart, you can make style choices for the columns/lines displayed for each indicator. The lines can be virtual or real, and the columns can be transparent
- Dimension display configuration, which limits the number of grouped displays under a dimension. The display quantity must be an integer between 1 and 1000, as shown in the following figure:
Coordinate Axis Configuration
The horizontal and vertical axes of the line column combination chart can display coordinate axis titles, and support customized modification of axis titles. The Y-axis supports customized axis intervals, making the columns and lines better highlight the hierarchical sense of actual business data and enhance data readability, as shown in the following figure:
Doughnut Chart
A doughnut chart is used to show the proportion relationship of different categorical variables. It is more suitable for displaying multiple categorical variables compared to a pie chart, typically displaying no more than 6 categories.
Data Configuration
The configuration of a doughnut chart requires a categorical data field (dimension) and a continuous data field (metric). In the context of a pie chart, the categorical data field should form a whole (e.g. in the example below, analyst, regular user, administrator, user operator form the entire user role) and should not be independent and unrelated, as shown below:
Index | Function | Description |
---|---|---|
1 | Visualization Component Preview Area | The overall area for previewing visualization components. The default report name is "New Report {number}" and can be customized as desired. |
2 | Data Configuration Area | Configuring the aggregation mode for dimensions/metrics in the field parsing area. A doughnut chart only supports one metric. |
3 | Field Setting Area | Metrics can be summed, averaged, counted, maximum, minimum, median, standard deviation, etc. See for details: .Data Processing and Transformation v2.5. |
4 | Field Parsing Area | The field parsing area contains all the fields in the table, drag the fields into the data configuration area for data calculation. |
Style Configuration
- Metric Display Configuration: The donut chart only supports configuring one metric, and you can choose whether to display data labels in the chart.
- Dimension Value Display Configuration: The maximum number of slices in the pie chart.
Pie Chart
The pie chart is suitable for displaying the proportional relationship of a single categorical variable, usually showing no more than 6 categories.
Data Configuration
The configuration of the pie chart requires a categorical data field (dimension) and a continuous data field (metric). See the following figure for details:
Index | Function | Description |
---|---|---|
1 | Visualization Component Preview Area | Overall area can be used for visual component preview. The default report name is "New Report {number}", but can be customized. |
2 | Data configuration area | Configure the summary mode of dimensions/metrics for each field in the field parsing area. Pie charts support only one metric |
3 | Field configuration area | Metrics can be summarized by sum, average, count, maximum value, minimum value, median, standard deviation, etc. Refer to: Data Processing and Processing |
4 | Field parsing area | Place all fields from the table in the field parsing area. Drag the fields into the data configuration area for data calculation |
Style configuration
- Metric display configuration: Only one metric can be configured for pie charts. You can choose whether to display data labels in the chart
- Dimension value display configuration: Select the maximum number of slices in the pie chart
Funnel Chart
Funnel Chart is an analytical tool that visually represents the conversion status of business processes. It is used for step analysis of a single process and describes the completion of business goals as the business process progresses.
Data configuration
Drag and drop the value field to "Funnel Step" and the dimension field to "Comparison Dimension", the chart preview area on the right side will be rendered automatically, and at least one funnel step needs to be configured in the Funnel Chart Data Configuration, as shown in the following figure:
Index | Function | Description |
---|---|---|
1 | Visualization component preview area | The overall area can be previewed with visual components, and the report name defaults to "New Report {Number}", which can be customized and modified at will |
2 | Funnel step configuration | The complete business nodes of the business funnel need to be sequentially configured in the form of indicators, and at least one funnel step needs to be configured in the funnel graph data configuration |
3 | Comparison dimension configuration | Comparison dimensionUp to 2 groups can be selected, and two funnels can be generated under the same funnel step and different dimensions for conversion rate comparison |
4 | Field parsing area | Place all fields in the table in the field parsing area, and drag the fields into the data configuration area for data calculation |
Style Configuration
The style configuration of the funnel chart is relatively simple. The funnel chart supports the display of legend labels and theme color configuration, as shown in the following figure:
Word Cloud Chart
Word cloud chart is generally used to display high-frequency words or other words that need to be highlighted
Data Configuration
After dragging the fields from the value area and dimension area to the corresponding configuration area, the preview area on the right side of the chart will be automatically rendered. For the word cloud chart, you need to select a field as the text content for display and select a field as the basis for calculating the text size, as shown below:
Index | Function | Description |
---|---|---|
1 | Visualization Component Preview Area | The overall area for previewing visualization components. The default report name is "New Report {number}", but you can customize it as needed. |
2 | Data Configuration Area | Select the content to be displayed in the word cloud and choose the corresponding metric for calculating the text size |
3 | Field Setting Area | Indicators can be summed, averaged, counted, maximum, minimum, median, standard deviation, etc. Please refer to:Data Processing and Processing |
4 | Field parsing area | Place all fields in the table in the field parsing area, and drag the fields into the data configuration area for data calculation |
Style Configuration
The style configuration of the word cloud graph is relatively simple. The style configuration of the word cloud graph supports displaying the number of legends and configuring the theme color. As shown in the following figure, we choose a mixed color:
Dash board
The dash board can be used to observe the position and progress of a certain indicator within the interval
Data configuration
Select an indicator as the observation object, set the initial value and target value as the observation interval, as shown in the following figure:
Index | Function | Description |
---|---|---|
1 | Visualization component preview area | The overall area can preview visual components, the default report name is "New report {number}", which can be customized as needed |
2 | Data configuration area | Configuring the summary mode of the fields in the data configuration area, the dashboard supports only one metric |
3 | Gauge scale area | Allows setting the scale range of the gauge, default to 0-1000 |
4 | Field parsing area | The field parsing area contains all the fields in the table. Drag the fields into the data configuration area for data calculation |
Style configuration
The style configuration of the dashboard is relatively simple, supporting the display of legend labels and theme color configuration, as shown in the following figure:
Metric card
The metric card can be used to display the value of the metric and its change in the current stage
Data configuration
Select one indicator for the data configuration of the indicator card to display the indicator values and the same month on month ratio, as shown in the following figure:
Index | Function | Description |
---|---|---|
1 | Visualize Component Preview | The overall area can be previewed with visual components, and the report name defaults to "New Report {Number}", which can be customized and modified at will |
2 | Data configuration area | Configure the summary mode of dimensions/indicators for each field in the field resolution area |
3 | Field parsing area | Place all fields in the table in the field parsing area, and drag the fields into the data configuration area for data calculation |
4 | Time filtering | Select the time range for the current metric card |
5 | MoM and YoY | Time granularity "hour": Calculate MoM for days Time granularity "hour": compared with the previous hour |
Style configuration
The style configuration of the metric card is relatively simple, supporting custom display of title, display of the current query time range, display of metric name, and color switching of rise and fall styles, as shown in the following figure: