Add a chart

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

    1. Click AddChart (Wizard).

    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 back 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. Open the dashboard to which you want to add a chart.

    2. In the upper-right corner, click Edit.

    3. Click AddChart (QL). 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.

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

    5. 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.

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

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

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

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