How to Create Dashboards

Dashboards let you put multiple queries on one page so you can see your key metrics at a glance. The queries on a dashboard can be table results, or charts. This feature is only available for Premium Team users.

Creating a dashboard

Look for the Dashboards tab in the top left of your screen and click New Dashboard. Your teammates will appreciate if you give your dashboard a name and description. 😊

Adding a query to a dashboard

When looking at a query, click Add to Dashboard. A modal will appear with a list of dashboards. You can also create a new dashboard from here.

When looking at a dashboard, look for the Search for a query... input and type the name of your query.

Removing a query from a dashboard

When looking at a dashboard, click on the dropdown menu on a query, and click Remove.

Using query variables with a dashboard

If any of the queries on your dashboard have variables, you'll see a list of variables and their values underneath the dashboard name. These values will be shared among every query that uses that respective variable.

If you want a specific query to use its own value for a variable, click Edit Variables.

Adding charts to a dashboard

If your query is chartable, click the dropdown near the top right of your widget, and hit View as chart.

Sharing a dashboard

When you first create a dashboard, it starts off private. When you're ready to share the dashboard with your team, click the Share button in the top right to make it viewable by your team. There, you can also find a URL for your dashboard.

Refreshing a dashboard

To refresh a dashboard, click the dropdown near the top right, and hit Refresh Queries. In the near future, we plan on adding automatic refreshes. Ping us at hi@popsql.com if this is something you'd like.

You can also refresh individual queries by clicking the dropdown on a query, and clicking Refresh Query.

Deleting a dashboard

All good things must come to an end. When you're ready to delete your dashboard, click the arrow on the top right and hit Delete.