Creating my first dashboard
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.
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:
SELECT *FROM Table_1;
After you've configured your dashboard specific dataset(s), you're now ready to create a data panel in Explo!
Simple drag and drop the Data Panel Component onto the canvas, and select the dataset you'd like to use.
Double click on the panel you created to access the editor. There are 3 separate sections in the editor.
Filter - filters allow you to include certain segments of your data in the panel. This is great for selecting a certain date range to show, excluding rows with null entries, and more.
Summarize - use the summarize tab to perform any sort of calculation you want to show on the data. Calculate monthly totals, average order value, or even single metrics such as a column total.
Visualize - select which visualization you want to display and configure parameters here.
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.
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.
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.
​
