GOAL: BUILD YOUR 1ST DASHBOARD

Community Maintained

In this guide, you will install and build a simple dashboard using Rocket.BI . This is the dashboard:

You can checkout the Dashboard via this link.

INSTALL

Start RocketBI with our pre-built docker images.

Get docker-compose.yml and configuration file:

Edit .clickhouse.env, add clickhouse server information.

Start RocketBI by run command: docker-compose up -d .

Open browser, go to localhost:5050, login with this account: hello@gmail.com/123456

To build from source or advanced configuration you could check it here Rocket.BI Readme

LET'S BUILD THE DASHBOARD

In Dashboard, you will find your reportings, start visualization by clicking +New

You can build unlimited dashboards & draw unlimited charts in a dashboard.

See hi-res tutorial on Youtube: https://www.youtube.com/watch?v=TMkdMHHfvqY

Build the Chart Controls

Create a Metrics Control

In the Tab filter, select metric fields you want to use. Make sure to keep check on aggregation setting.

Rocket BI metrics control configuration panel showing selected fields and aggregation settings - Zoomed

Rename filters & Save Control to Dashboard

Metrics control with renamed filters ready to save to dashboard - Zoomed

Create a Date Type Control

Choose a Date field as Main Date column:

Date field selection interface in Rocket BI showing available date columns - Zoomed

Add duplicate variants with different lookup ranges. For example, Year, Monthly, Daily date or Day of Week.

Date range configuration showing different time period options like year, month, and day - Zoomed

Rename filters & Save Control to Dashboard

Date range control with renamed filters ready to save to dashboard - Zoomed

Now, let build the Charts

Pie Chart: Sales Metrics by Regions

Choose Adding new chart, then Select Pie Chart

Chart type selection panel with pie chart option highlighted - Zoomed

First Drag & Drop the column "Region" from the Dataset to Legend Field

Drag and drop interface showing Region column being added to legend field - Zoomed

Then, change to Chart Control Tab

Chart control tab interface showing visualization configuration options - Zoomed

Drag & Drop the Metrics Control into Value Field

Metrics control being added to the value field of the pie chart - Zoomed

(you can also use Metrics Control as Sorting)

Navigate to Chart Setting for further customization

Chart settings panel showing customization options for the pie chart - Zoomed

For example, change Data label to Percentage

Data label settings being changed to show percentages on the pie chart - Zoomed

Save & Add the Chart to Dashboard

Dashboard view showing the newly added pie chart with other controls - Zoomed

Use Date Control in a Time-series Chart

Let Use a Stacked Column Chart

Stacked column chart creation interface with time-series data - Zoomed

In Chart Control, use Metrics Control as Y-axis & Date Range as X-axis

Chart control configuration showing metrics on Y-axis and date range on X-axis - Zoomed

Add Region column in to Breakdown

Region column being added as breakdown dimension in the stacked column chart - Zoomed

Adding Number Chart as KPIs & glare-up the Dashboard

Complete dashboard with KPI number charts, pie chart, and time-series visualization - Zoomed

Now, you had successfully build your 1st dashboard with rocket.BI

INSTALL​

LET'S BUILD THE DASHBOARD​

Build the Chart Controls​

Create a Metrics Control​

Create a Date Type Control​

Now, let build the Charts​

Pie Chart: Sales Metrics by Regions​

Use Date Control in a Time-series Chart​

Try ClickHouse Cloud for FREE