Dashboard management

This topic describes how to create and manage dashboards in a workspace.

Background information

The OceanBase Cloud dashboard allows you to monitor and analyze massive amounts of data in real time, helping you better understand your business and improve your operational efficiency and decision-making capabilities. The dashboard provides data visualization features, converting complex data into easy-to-understand charts, to help you better understand and utilize the data.

The example below will guide you through the process of creating a workspace, a dashboard named test_employee, and adding a bar chart named bar_employee to the dashboard.

Procedure

Step 1: Create a dashboard

1. Log in to the OceanBase Cloud console. In the left-side navigation pane, click Instances to create an analytical instance and a super administrator account.

2. In the workspace list, click the name of the target workspace to go to the corresponding workspace.

   

3. In the left-side navigation pane of the workspace page, click Dashboards. On the dashboard page, click Create Dashboard to create a dashboard.

   

Step 2: Add a chart to the dashboard

You can add a chart to the dashboard or use a chart from the result tab of a SQL statement execution.

1. Open the created dashboard and click Create Chart to add a chart to the dashboard.

   

   Note

   You can double-click or right-click the name of a dashboard in the SQL window to rename the dashboard.
   

2. In the newly created chart, click the more icon and then click Edit.

   

3. Click the Data Source icon in the toolbar to switch to the test1 database. Then, edit and execute the SQL statement to query data in the employee table.

   SELECT `emp_no`, `birthday`, `name`, `salary`, `time` FROM `employee`;
   

   

   Note

   You can double-click or right-click the name of a chart in the SQL window to rename the chart.
   

4. On the result tab, click the icon, select the bar chart, and configure the X and Y axes. Then, click Refresh Chart.

5. In the toolbar, click the save icon to save the chart. You can also click the icon on the result tab to save the configured chart to the dashboard.

   

6. In the dashboard list, view the information about the added chart.

   

Manage the dashboard

Manage dashboards

Manage charts

In the dashboard list, click the more icon next to the name of a chart, select Edit from the drop-down list, and then click the chart to go to the chart list page.

Action	Description
Add a chart	In the toolbar of the dashboard page, click the plus sign (+) to add a chart.
Arrange charts	In the toolbar of the dashboard page, click the icon to arrange the charts in 1 row with 1 column, 2 columns, or 3 columns.
Save the dashboard	In the toolbar of the dashboard page, click the icon to save the dashboard.
Refresh the chart list	In the toolbar of the dashboard page, click the icon to refresh the chart list.
Download the current chart data	In the toolbar of the dashboard page, click the icon to download the data of the current chart.
Rename the chart	Click the more icon next to the name of a chart, and then click to rename the chart.
Zoom in on the chart	In the chart list, click the icon next to the chart to zoom in on the chart.
Refresh the current chart data	In the chart list, click the icon next to the chart to refresh the data of the current chart.
Edit the chart	In the chart list, click the more icon next to the chart, select Edit from the drop-down list, and then click the chart to edit it.
Copy the chart	In the chart list, click the more icon next to the chart, select Copy from the drop-down list, and then click the chart to copy it.
Delete the chart	In the chart list, click the more icon next to the chart, select Delete from the drop-down list, and then click the chart to delete it.

Edit a chart

In the chart list, click the more icon next to the name of the chart that you want to edit and choose Edit.

Button	Description
Switch to the chart	On the result tab, click the icon to view and edit the current chart.
Download the chart	On the result tab, click the icon to download the current chart.
Save the chart to the dashboard	On the result tab, click the icon to save the current chart to the dashboard.