Using SQL Notebook
Last updated
Last updated
Follow these steps to create a dashboard using a SQL Notebook:
Go to the 'SQL Notebook' tab under the 'Notebook' dropdown in the navigation bar.
Create a SQL Notebook, write and run a SQL query. The results will appear in the 'Data' tab.
Switch to the 'Metrics' tab to enter Distributed metric mode. Here, you can create charts by dragging dimensions and measures into the X and Y axes. 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.
Once your chart is ready, you can save it by clicking 'Save as DM' (for Distributed mode) or 'Save as AM' (for Aggregated mode).
To create a dashboard, click the 'Dashboard' tab at the top of the notebook. From the list of available metrics, select the ones you want and click 'Go to Dashboard'. Provide the dashboard name and description, then click 'Add' to create it.