Using the BDP Personal Edition tool, let's explain the operation steps below:
The first type: 1 dimension+1 comparison+1 value, which is a traditional "population pyramid" diagram. Take the statistics of used car mileage of different manufacturers (FAW-Volkswagen vs Shanghai GM) as an example, and some data are as follows:
First, after uploading/accessing the data to BDP Personal Edition, click "New Chart";
Second, in order to better analyze the mileage, first create a grouping field (the grouping field is very useful, remember to collect it), click the+on the right side of the field, select Add Grouping Field, edit the field name, and set grouping conditions in the bomb layer, as shown below ~
Note: You can select the field (mileage) to be grouped in the "Grouping Field" drop-down box; You can choose fixed step size, user-defined step size and expression as grouping methods. In this case, a fixed step size is selected and the grouping step size is set to 1.
Finally, drag the fields to be analyzed into the corresponding dimension, comparison and value columns, and our comparison bar chart is completed ~
During comparative analysis, the system will automatically compare the first two data of "Supplier". Of course, you can also drag the "supplier" field to the filter on the left to filter different comparison data ~
From the figure, you can immediately know the number of vehicles in different mileage between FAW-Volkswagen and Shanghai GM, and the comparative analysis is clear at a glance.
The second value: 1 dimension +2, just drag the field you want to analyze to the dimension for comparison &; In the numerical column, select the comparison bar chart, as shown below ~
From the above picture, we can intuitively compare and analyze the comprehensive score and environmental score of restaurants in different regions. Data source: BDP data source-public data-local life data, please help yourself!