If you have read Dashboard overview and Dashboard basic operations, read this section to learn about how to create a table. If you need to edit the dataset or create a new dataset, see Create a dataset.
A table is used to show the values of a table field and divide the values into two groups. One group is listed on the left of the data table, and the other is listed on the top of the data table. Multiple calculations can be performed in the intersection between a column and a row, for example, sum, average, count, maximum, or minimum.
A table consists of rows and columns. The horizontal rows are determined by the data dimension, such as a province or a product type. The vertical columns are determined by the data measurement, such as an order quantity or a profit amount.
Notice on creating a table
No restrictions are imposed on the values of the dimension and measurement to define the rows and columns of a table.
The following uses the company_sales_record dataset as an example.
Scenario: Compare the packages, transportation costs, order quantities, and average profits of different types of products in multiple provinces.
- Log on to the Quick BI console.
- Click Datasets to enter the dataset management page.
- Select company_sales_record dataset, and click Create Dashboard.
- Click table icon.
- On the Data tab, select a required dimension field and measurement field.
In the dimension list, locate the province, product_type, and product_box options and add them to the row area in sequence. In the measurement list, locate the order_amt, shipping_cost, and average_profit options and add them to the column area in sequence, as shown in the following figure.
Note Make sure that the dimension type of the region and province fields have been switched from string to geological information.
- Click Update. The system automatically updates the chart.
- On the Style tab, you can edit the title and layout.
In the Rule menu, you can edit the data display effect for the table, for example, you can change the font color, add a data identifier, or highlight a data area, to help readers efficiently locate their expected data.
- Click the Save icon to save the dashboard.
To delete the current chart, point to the upper-right corner of the chart, and choose Delete from the shortcut menu.