title_wip

[Edit this page](https://github.com/ClickHouse/clickhouse-docs/blob/main/docs/integrations/data-visualization/community_integrations/rocketbi-and-clickhouse.md)

Community Maintained

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

![Rocket BI dashboard showing sales metrics with charts and KPIs](/docs/assets/images/rocketbi_01-7187cf887c5c8ca06851da87bbe1c6ea.gif)

  

You can checkout [the Dashboard via this link.](https://demo.rocket.bi/dashboard/sales-dashboard-7?token=7eecf750-cbde-4c53-8fa8-8b905fec667e)

## Install[​](#install "Direct link to Install")

Start RocketBI with our pre-built docker images.

Get docker-compose.yml and configuration file:

```
wget https://raw.githubusercontent.com/datainsider-co/rocket-bi/main/docker/docker-compose.yml
wget https://raw.githubusercontent.com/datainsider-co/rocket-bi/main/docker/.clickhouse.env
```

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: `[email protected]/123456`

To build from source or advanced configuration you could check it here [Rocket.BI Readme](https://github.com/datainsider-co/rocket-bi/blob/main/README.md)

## Let's build the dashboard[​](#lets-build-the-dashboard "Direct link to 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.

![Animation showing the process of creating a new chart in Rocket BI](/docs/assets/images/rocketbi_02-9e1cef470914f0a6762527bb8ead538a.gif)

  

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

### Build the chart controls[​](#build-the-chart-controls "Direct link to Build the chart controls")

#### Create a metrics control[​](#create-a-metrics-control "Direct link to Create a metrics control")

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

  

Rename filters & Save Control to Dashboard

#### Create a date type control[​](#create-a-date-type-control "Direct link to Create a date type control")

Choose a Date field as Main Date column:

  

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

  

Rename filters & Save Control to Dashboard

### Now, let build the Charts[​](#now-let-build-the-charts "Direct link to Now, let build the Charts")

#### Pie chart: sales metrics by regions[​](#pie-chart-sales-metrics-by-regions "Direct link to Pie chart: sales metrics by regions")

Choose Adding new chart, then Select Pie Chart

  

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

  

Then, change to Chart Control Tab

  

Drag & Drop the Metrics Control into Value Field

  

(you can also use Metrics Control as Sorting)

Navigate to Chart Setting for further customization

  

For example, change Data label to Percentage

  

Save & Add the Chart to Dashboard

#### Use date control in a time-series chart[​](#use-date-control-in-a-time-series-chart "Direct link to Use date control in a time-series chart")

Let Use a Stacked Column Chart

  

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

  

Add Region column in to Breakdown

  

Adding Number Chart as KPIs & glare-up the Dashboard

  

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

- [Install](#install)- [Let's build the dashboard](#lets-build-the-dashboard)
    - [Build the chart controls](#build-the-chart-controls)- [Now, let build the Charts](#now-let-build-the-charts)

Was this page helpful?