Using SQL Editor
Last updated
Last updated
Follow these steps to create a dashboard using a SQL Editor:
Go to the 'SQL Editor' tab.
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.
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.
For Aggregated metrics, choose a metric from the dropdown, select a function (SUM, AVG, COUNT, MAX), and provide a chart name.
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.
