Collect the specific data on dashboard views of users after login, including username, access time, visits to each dashboard, etc.
Which dashboards have been viewed by whom and how many times.
Which dashboards are active and which are not.
Which dashboards are used more frequently in which scenarios.
Use the Template Execution Log table under the user access log for analysis.
Sections “Creating a Dashboard” and "Component for Viewing Top 10 Dashboards by Usage Time" of this article provide two examples of component analysis. Users can also make their own analysis dashboards with reference to the expected effects in "Expected Effect".
1. Create a new analysis subject and add a dataset: Template Execution Log.xlsx.For details, see Getting Started with FineBI
(2) Use the formula INDEXOF(SPLIT (tname, "/"), LEN (SPLIT (tname, "/"))-1) to extract the dashboard name in the tname field and name the column as Access Dashboard, as shown in the following figure.
Description of the formula:
SPLIT (field, "/")
Split fields into arrays by slash(/).
Before the split: a/b/c
After the split: a, b, c
LEN (SPLIT(field, "/"))-1
Count the number of arrays after fields are split by slash(/) - 1
For example, the calculation result of field a/b/c is 2.
INDEXOF (SPLIT(field, "/"), LEN (SPLIT (field, "/"))-1)
Return the character after the last slash(/) of the array after SPLIT.
For example, the calculation result of field a/b/c is c.
3. Click the Save and the Update button, as shown in the following figure.
Procedure
1. Click Component in the lower left corner, as shown in the following figure.
2. Select the partition column chart, drag tname into the vertical axis and rename it to Access Dashboard, and drag count into the horizontal axis, as shown in the following figure.
3. Exchange fields of horizontal and vertical axes.
Hover the cursor between the horizontal axis and the vertical axis, and click the button to exchange fields of horizontal and vertical axes, as shown in the following figure.
4. Display data in descending order according to the count.
Click the drop-down box of the Access Dashboard field and select Descend > Count (Sum), as shown in the following figure.
5. Click the drop-down box of the Count field, select Filter, set filter conditions, and click OK, as shown in the following figure.
Effect Display
Use a column chart to view the top 10 dashboards by usage time, as shown in the following figure.
1. Click the Add Component button, create another component, and copy Count.
2. Rename the new field to Edit Times, set the indicator conditions, and filter out the data with type 102 (namely, the access type is editing), as shown in the following figure.
3. Copy Count and rename the new field to View Times. Set the indicator conditions, and filter out the data with type 101 (namely, the access type is viewing), as shown in the following figure.
4. Select Custom Chart under Chart Type, drag the time field into the horizontal axis, drag the Count, Edit Times, and View Times fields into the vertical axis, and rename Count to Operation Times, as shown in the following figure.
Click Operation Times under Graphic Properties, and select Line for the graph, as shown in the following figure.
Click Edit Times, and select Column Chart as the graph. The steps are the same as above.
Click View Times, and select Column Chart as the graph. The steps are the same as above.
You can observe the visit times, view times, and edit times of the dashboard, and overall evaluate the activity of the dashboards, as shown in the following figure.
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy