Create a chart

To add a chart to your dashboard, follow the steps below:

  1. In the upper-right corner of your workbook page, click CreateWizard chart.

  2. Open your dashboard.

  3. Click AddChart.

  4. Select a dataset from the list.

  5. Click the chart type field on the right of the dataset section and select the type from the drop-down list.

  6. Drag and drop Measures and Dimensions to the appropriate sections of the chart. Depending on the chart type, specify any other settings. Your chart will appear in the workspace on the right.

  7. Click Save in the upper-right corner of the page.

  8. Give your chart a name and click Done.

  9. Choose the right location for your chart by dragging it around the dashboard.

  10. Click Save in the upper-right corner of the page.

Warning

Before creating a QL chart, configure the connection the data from which you want to visualize:

  1. Go to your Workbook page.

  2. Under Connections, open the information page of the connection you want to visualize.

  3. Under Raw SQL level, select Allow subselects in datasets and queries from charts.

  4. Click Save changes.

  1. In the upper-right corner of your workbook page, click CreateQL Chart. You'll see the chart creation interface. It consists of two main sections:

    • Query section. Here you can write the SQL query you want to visualize.

    • Chart and dataset preview section. Here you can select the chart type you want to apply to your visualization.

      Below the chart preview, you'll see the data table consisting all the data received from your cluster via the SQL query.

  2. In the Query section, under Select connection to start, click Select. Choose the connection to the database you want to visualize.

  3. Write a query for the data visualization:

    ![ql-chart-query](../../../_assets/data-visualization/concepts-charts/ql-chart-query.png "QL chart query example" ==80x)

    Tip

    In this section, DoubleCloud Visualization uses a live suggestions engine to accelerate and simplify query writing.

  4. In the chart and dataset preview section, click the chart type to select the visualization suitable for your data (line chart by default).

  5. Click Run to see the chart preview with the visualized data from the query.

  6. Click Save in the upper-right corner of the page.

You can create the following chart types with DoubleCloud API:

For detailed instructions on how to describe a chart type, click one of the links above and select the API tab.

To learn more about each chart type's features, see Charts reference.