You can use the Value Format function to set the quantity unit of values to thousand and million. This document introduces how to customize the value format.
1. Choose the unit you want to display and the existing data.
2. Add a Calculation Indicator field, with a value of current data/the ratio of current data to the unit. For example, if you want to convert 30000000 to 30 million, the value should be 30000000/10000000.
3. Drag the added Calculation Indicator field into the Data.
You can use the example data table Regional Data Analysis to display the Contract Amount as a value in units of 10 million.
1. Log in to the system as the admin, click My Analysis, select a folder, and click New Subject, as shown in the following figure.
2. Click Local Excel and click Upload Data, as shown in the following figure.
You can download the example data. Regional Data Analysis.xlsx
3. After the data is uploaded, click OK.
4. Click Component in the lower left corner.
5. Click the Detail Table icon in Chart Type, and drag the Contract Amount field into the Data.
Note:The second step in the following figure is to facilitate comparison with the values of new quantity units. You may ignore this step in the actual process.
Add a Calculation Indicator field. If you want to convert the current value unit to 10 million, you can divide the current value by the ratio of the current data to the unit.
1. Drag the Calculation Indicator field into the Data.
2. Double-click the Calculation Indicator field to rename it Contract Amount (10 million).
On PC
On Mobile Terminals
The following figure shows the preview effect on the DataAnalyst app and in HTML5.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy