To view the status of data transfer in a dashboard when importing or exporting data, you can use the progress bar feature of the table.
Prerequisites
Log data is collected. For more information, see Collect text logs from servers.
Indexes are created. For more information, see Create indexes.
Step 1: Query and analyze data
Log on to the Simple Log Service console. In the Projects section, click the project you want.
In the left-side navigation pane, click Log Storage. In the Logstores list, click the logstore you want.
Enter the query and analysis statement, and then click Last 15 Minutes to set the time range for your query and analysis.
For example, you can use the following query and analysis statement to view the path and import volume of a file.
* | select split_part(request_uri,'?',1) as path, count(1) as count group by split_part(request_uri,'?',1) order by count desc limit 10
Step 2: Add a table
In the left-side navigation pane, choose Dashboard > Dashboards. In the dashboard list, click the dashboard you want. In the upper-right corner of the dashboard page, click Edit. In edit mode, click Add > Add Chart.
On the General Configurations tab, click the Table Pro icon in the Chart Types section. On the Search & Analysis tab, select Logstore (SQL) and choose the logstore you want, and enter the query statement. Select a time range, such as Last 15 Minutes, and click OK.
Step 3: Add a progress bar
Add a filled progress bar
On the Field Configuration tab, click Add Field, and then select the column name from the drop-down list.
Click Add Configuration, and then select Field/Column Settings > Maximum Value. Set the value corresponding to 100% progress, such as 500.
Use the same method to set Color Scheme to Threshold, Cell Display Mode to Progress Bar, and Threshold to your desired value, such as 400.
The settings and results are shown in the figure below.
Add an LCD progress bar
On the Field Configuration tab, click Add Field, and then select the column name from the drop-down list.
Click Add Configuration, and then select Field/Column Settings > Maximum Value. Set the value corresponding to 100% progress, such as 500.
Use the same method to set Color Scheme to Threshold, Cell Display Mode to LCD Progress Bar, and Threshold to your desired value, such as 400.
The settings and results are shown in the figure below.
Add a gradient progress bar
On the Field Configuration tab, click Add Field, and then select the column name from the drop-down list.
Click Add Configuration, and then select Field/Column Settings > Maximum Value. Set the value corresponding to 100% progress, such as 500.
Use the same method to set Color Scheme to Threshold, Cell Display Mode to Gradient Progress Bar, and Threshold to your desired values.
The settings and results are shown in the figure below.
