|
The general manager of sales established a database table containing user name and image column, hoping to collect the data analysis dashboard of sales managers in each region. The dashboard includes image and document. The following is how to make a sales dashboard for each region. 1. Data preparation Data preparation is consistent with the general dashboard, please refer to the data preparation. It should be noted that the data type of the image and document is the binary object data type. 2.Make form in the dashboard 1)Create a new dashboard and select the form parameter component from the right side, as shown in the figure below. 2)Select the sales data dataset of each region, and bind the "User name", "Image" and "Document" under the dimension and measurement to the data column, as shown in the figure below. 3)Select the column of the "User name", click the [Setting> Form Editor] on the right, and select the default value in the dropdown option:?{_ USER _}, and close the editable switch. 4)Select the column of "image", click the [Setting> Form Editor] on the right, related settings: binary object data type control is the file, select the image in the dropdown option of layout method, select the image in the drop-down option of the file type, the file format select jpg, jpeg, png in the drop-down option, the file size is 1024 KB. After the setup completes, click OK. 5)Select the column of "document", click [Setting> Form Editor] on the right, related settings: binary object data type control for a file, display the file name in the dropdown option, drop in the file type, file format select Word, Excel, PDF in the dropdown option, file size is 1024 KB. After the setup completes, click OK. 6)Click on the top menu [Form> Form Mapping], create mapping relationship, select the mapping "connection" and "table" after the "click "auto match field group", automatic matching source field and target field, and check the user name line corresponding condition check box, in the lower commit type select" intelligent commit ", set complete, click" OK ". 7)Save the dashboard. 3.Complete the form Sales manager logs in the product, opens the sales data analysis and form dashboard of each region, selects the picture column and document column respectively, and uploads the sales data analysis picture dashboard and document dashboard of the region. The user list will be filled in automatically according to the login user, and cannot be modified. After filling, click the commit button, the page prompts the successful commit and refresh the dashboard. Follow-up sales manage needs to update the dashboard. If you need to replace the data analysis dashboard, click the replace button, select the file in the corresponding format to upload, and refresh the dashboard after commit. If you need to delete the data analysis dashboard, click the delete button and refresh the dashboard after commit. 4.View form After the data analysis dashboard of the sales manager in each region is completed, the sales general manager opens the form dashboard and views the dashboard. Click the picture dashboard uploaded in the picture column, you can click the full screen icon to view the picture dashboard in full screen mode; drag the slider at the top of the picture page to zoom in and reduce the zoom in to 10%~200%; click the rotating icon to switch different angles; you can click to download the icon to download the picture dashboard to the local view. Click on the Excel dashboard of the document column can also be downloaded for local viewing. 5.Other This chapter simply uses the use of the form parameter component to form in the document. You can also use the freestyle form component to form in the document. If only one or a small number of documents are involved in the whole dashboard, you can also use the upload component to form in, for usage, refer to the upload component.
| 
