Follow along to this article to get started creating your first dashboard!
Set up your datasets
The first step to building your dashboard is to create dashboard-specific datasets. Although this is not required, this allows you to configure viewing permissions, configure variables, and optimize your queries that are specific to each dashboard.
Create datasets in the editor on the bottom of your page
Even if you don't require any additional changes to your data, we suggest you create a new dataset and select entire tables as shown below:
1
SELECT*
2
FROM Table_1;
Copied!
Create your first data panel
After you've configured your dashboard-specific dataset(s), you're now ready to create a data panel in Explo!
Simple drag and drop a Chart Component onto the canvas, and select the dataset you'd like to use.
Drag on a Data Panel to create visualizations
Double click on the panel you created to access the editor. There are 2 separate sections in the editor.
Data - select which visualization to use and configure the aggregations, filters, and different parameters
Format - format your visualizations that adjust labels, colors, text, and more
We encourage users to build visualizations from dashboard-specific datasets for each dashboard and not source datasets. This allows you to configure variables for drop-downs, user access controls, and other custom variables to interact with your dashboard.
Add additional components and configure variables
Adding components
Add additional components to your dashboard by dragging and dropping them onto your canvas.
Configure variables in your datasets
Some components such as date selectors and dropdowns require you to add variables into your SQL queries. For more information on how to configure variables, click here.
Share and embed
Once your dashboard is complete, you're ready to embed or share the dashboard! Please ensure that your user groups are set before this step to ensure your customer are only seeing their own data.
For more details on how to embed a dashboard, click here.
If you want your users to be able to share links or download the dashboards as a pdf, simply drag a Share component onto your dashboard.