> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-trino-dialect.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> RocketBI is a self-service business intelligence platform that helps you quickly analyze data, build drag-n-drop visualizations and collaborate with colleagues right on your web browser.

# Goal: build your first dashboard with Rocket.BI

export const CommunityMaintainedBadge = () => {
  return <div className="CommunityMaintainedBadge">
            <div className="CommunityMaintainedIcon">
            <svg xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="currentColor" viewBox="0 0 256 256">
                <path d="M244.8,150.4a8,8,0,0,1-11.2-1.6A51.6,51.6,0,0,0,192,128a8,8,0,0,1-7.37-4.89,8,8,0,0,1,0-6.22A8,8,0,0,1,192,112a24,24,0,1,0-23.24-30,8,8,0,1,1-15.5-4A40,40,0,1,1,219,117.51a67.94,67.94,0,0,1,27.43,21.68A8,8,0,0,1,244.8,150.4ZM190.92,212a8,8,0,1,1-13.84,8,57,57,0,0,0-98.16,0,8,8,0,1,1-13.84-8,72.06,72.06,0,0,1,33.74-29.92,48,48,0,1,1,58.36,0A72.06,72.06,0,0,1,190.92,212ZM128,176a32,32,0,1,0-32-32A32,32,0,0,0,128,176ZM72,120a8,8,0,0,0-8-8A24,24,0,1,1,87.24,82a8,8,0,1,0,15.5-4A40,40,0,1,0,37,117.51,67.94,67.94,0,0,0,9.6,139.19a8,8,0,1,0,12.8,9.61A51.6,51.6,0,0,1,64,128,8,8,0,0,0,72,120Z"></path>
            </svg>
        </div>
            Community maintained
        </div>;
};

export const Image = ({img, alt, size = "lg", background}) => {
  const normalizedSize = ["sm", "md", "lg"].includes(size) ? size : "lg";
  const backgroundColor = background === "white" ? "white" : background === "black" ? "rgb(31 31 28)" : undefined;
  return <div className={`ch-image-${normalizedSize}`}>
      <Frame>
        <img src={img} alt={alt} style={{
    backgroundColor
  }} />
      </Frame>
    </div>;
};

<CommunityMaintainedBadge />

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

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_01.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=5b7cabc0ddee7c33064006c4e6e19025" alt="Rocket BI dashboard showing sales metrics with charts and KPIs" border width="1200" height="651" data-path="images/integrations/data-visualization/rocketbi_01.webp" />

<br />

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

<h2 id="install">
  Install
</h2>

Start RocketBI with our pre-built docker images.

Get docker-compose.yml and configuration file:

```bash theme={null}
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: `hello@gmail.com/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)

<h2 id="lets-build-the-dashboard">
  Let's build the dashboard
</h2>

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

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

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_02.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=54a12eb73e12e254da25ca7e3c054d7a" alt="Animation showing the process of creating a new chart in Rocket BI" border width="800" height="434" data-path="images/integrations/data-visualization/rocketbi_02.webp" />

<br />

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

<h3 id="build-the-chart-controls">
  Build the chart controls
</h3>

<h4 id="create-a-metrics-control">
  Create a metrics control
</h4>

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

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_03.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=9433cc49711cf6e8a81a78d2e70f2c6e" alt="Rocket BI metrics control configuration panel showing selected fields and aggregation settings" border width="1646" height="863" data-path="images/integrations/data-visualization/rocketbi_03.webp" />

<br />

Rename filters & Save Control to Dashboard

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_04.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=4572c04a2e14ddd6ab6cc82ca3973891" alt="Metrics control with renamed filters ready to save to dashboard" border width="1156" height="138" data-path="images/integrations/data-visualization/rocketbi_04.webp" />

<h4 id="create-a-date-type-control">
  Create a date type control
</h4>

Choose a Date field as Main Date column:

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_05.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=9eb276f731345005f5e23bb19ad18d58" alt="Date field selection interface in Rocket BI showing available date columns" border width="1646" height="863" data-path="images/integrations/data-visualization/rocketbi_05.webp" />

<br />

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

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_06.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=efb7202a7355b6389b0774fb903ceb40" alt="Date range configuration showing different time period options like year, month, and day" border width="1646" height="863" data-path="images/integrations/data-visualization/rocketbi_06.webp" />

<br />

Rename filters & Save Control to Dashboard

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_07.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=dd4f108916ce7718d37c73e2e52b25b9" alt="Date range control with renamed filters ready to save to dashboard" border width="346" height="444" data-path="images/integrations/data-visualization/rocketbi_07.webp" />

<h3 id="now-let-build-the-charts">
  Now, let build the Charts
</h3>

<h4 id="pie-chart-sales-metrics-by-regions">
  Pie chart: sales metrics by regions
</h4>

Choose Adding new chart, then Select Pie Chart

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_08.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=cb2b94c6a4c1b0f117a3b9469fa88141" alt="Chart type selection panel with pie chart option highlighted" border width="1860" height="1312" data-path="images/integrations/data-visualization/rocketbi_08.webp" />

<br />

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

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_09.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=908e1e66ee3c5c6079c563bf77754411" alt="Drag and drop interface showing Region column being added to legend field" border width="2562" height="1486" data-path="images/integrations/data-visualization/rocketbi_09.webp" />

<br />

Then, change to Chart Control Tab

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_10.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=1134061d0927d103a5ad322ab61bb7c0" alt="Chart control tab interface showing visualization configuration options" border width="1420" height="918" data-path="images/integrations/data-visualization/rocketbi_10.webp" />

<br />

Drag & Drop the Metrics Control into Value Field

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_11.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=0c0e8efbdf35c2789108b11d07f20c9d" alt="Metrics control being added to the value field of the pie chart" border width="2532" height="1484" data-path="images/integrations/data-visualization/rocketbi_11.webp" />

<br />

(you can also use Metrics Control as Sorting)

Navigate to Chart Setting for further customization

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_12.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=cfeb7165f2457d489c7ba8e8ec7acbc1" alt="Chart settings panel showing customization options for the pie chart" border width="1130" height="806" data-path="images/integrations/data-visualization/rocketbi_12.webp" />

<br />

For example, change Data label to Percentage

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_13.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=4e42e94b4e91c6ed5b86268a353d7a05" alt="Data label settings being changed to show percentages on the pie chart" border width="2534" height="1468" data-path="images/integrations/data-visualization/rocketbi_13.webp" />

<br />

Save & Add the Chart to Dashboard

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_14.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=7b49900606df274ec930233e978ea2bc" alt="Dashboard view showing the newly added pie chart with other controls" border width="1566" height="1056" data-path="images/integrations/data-visualization/rocketbi_14.webp" />

<h4 id="use-date-control-in-a-time-series-chart">
  Use date control in a time-series chart
</h4>

Let Use a Stacked Column Chart

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_15.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=70573caaab281e8525958d3c06c1fce2" alt="Stacked column chart creation interface with time-series data" border width="1836" height="1332" data-path="images/integrations/data-visualization/rocketbi_15.webp" />

<br />

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

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_16.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=1d1ff520e45f0106a538c38aed50a5ab" alt="Chart control configuration showing metrics on Y-axis and date range on X-axis" border width="2552" height="1496" data-path="images/integrations/data-visualization/rocketbi_16.webp" />

<br />

Add Region column in to Breakdown

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_17.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=425565c19b5987d5848b97f3ac701884" alt="Region column being added as breakdown dimension in the stacked column chart" border width="2552" height="1496" data-path="images/integrations/data-visualization/rocketbi_17.webp" />

<br />

Adding Number Chart as KPIs & glare-up the Dashboard

<Image size="md" img="https://mintcdn.com/private-7c7dfe99-trino-dialect/Fe5ef3I_HK9QFEGU/images/integrations/data-visualization/rocketbi_18.webp?fit=max&auto=format&n=Fe5ef3I_HK9QFEGU&q=85&s=a28759eabae703d03e02d2a4d0f44022" alt="Complete dashboard with KPI number charts, pie chart, and time-series visualization" border width="2788" height="1506" data-path="images/integrations/data-visualization/rocketbi_18.webp" />

<br />

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