> For the complete documentation index, see [llms.txt](https://docs.autonmis.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.autonmis.com/create-and-manage-your-first-dashboard/create-dashboards-from-sql-editor-or-sql-notebook/using-sql-editor.md).
# Using SQL Editor
Follow these steps to create a dashboard using a SQL Editor:
1. Go to the **'SQL Editor'** tab.
2. Create a chart, write and run a SQL query to retrieve data. The query results will be displayed under the **'Data'** tab in the 'Visualize' section.
3. Click the **'Metrics'** tab to enter **Distributed metric mode** and drag dimensions and measures into the X-axis and Y-axis fields to create a chart. You can also select the chart type (Line, Area, Bar, Pie), and add a **chart name** and **description**.
4. For Aggregated metrics, choose a metric from the dropdown, select a function (SUM, AVG, COUNT, MAX), and provide a chart name.
5. To publish the chart within a dashboard, click on the **'Publish Chart'** button. This will display a list of existing dashboards. If you want to create a new dashboard, click on the **'Add Dashboard'** button. A popup will prompt you to provide the **dashboard name and description**.
After entering these details, click **'Add'** to create the new dashboard. Then, select the newly created dashboard from the dropdown and click **'Publish'** to publish the chart within that dashboard.