A table can be used to display the distribution and total of specific variables. One variable defines the values in the header row and the other variable defines the values in the header column. The intersections of rows and columns contain the results of calculations on the data, such as the sum, average, maximum, minimum, or count of the data.
A table consists of rows and columns. Rows are determined by data dimensions, such as province and product type. Columns are determined by data measures, such as order quantity and profit amount.
For each table, the numbers of dimensions and measures are unlimited.
The following scenario uses the company_sales_record dataset as an example.
Scenario: Compare multiple types of products with different package designs, transportation costs, order quantities, and profit amounts across multiple provinces
- Log on to the Quick BI console.
- Click Datasets to open the dataset management page.
- Select the company_sales_record dataset and click Create Dashboard.
- Click the table icon and the corresponding legend is displayed.
- Click the Data tab to select data dimensions and data measures.
In the Dimensions list, select province, Product_type, and Product_box, and add them sequentially to Row. In the Measures list, select order_amt, shipping_cost, and average_profit, and add them sequentially to Column, as shown in the following figure:Note Make sure you have changed the data type of Province from String to Location.
- Click Update to generate the table.
- In the Style tab, you can change the title, layout, style, and rules of the table.
In the Rules section, you can change the style of the data so that viewers can quickly find important data. For example, change the font color, add marks to specific data, or highlight cells based on custom rules.
- Click the Save icon to save the dashboard.
To delete the table, move the mouse to the upper-right corner and click Delete in the toolbar that appears.