Skip to main content

Exploring your content

Browsing the saved charts and dashboards in your projectโ€‹

The easiest way to get started in Lightdash is to check out the saved charts and dashboards that your team's already made. You can see a list of some of this content on your homepage as soon as you land in Lightdash.

You can always get back to your homepage by clicking on the Lightdash icon in the top-left corner of your screen.

You can also browse the lists of all of the saved charts, dashboards, and Spaces that you and your teammates have made in your project by clicking on Browse in your navbar.

If you already know what you're looking for, then you can use the search bar to search through all of the content in your Lightdash project. Just click on search in the navbar, or click cmd + K to open the search bar.

This global search matches content from everywhere in the project: dashboard names, field descriptions, table names, saved chart descriptions, etc.

Exploring data in a chartโ€‹

View underlying data in a chart or your results tableโ€‹

You can click on any point on a chart or any cell in a results table and view the records which make up that data point.

For example, I can click on the page views bar in my chart or the value in the results table cell and I'd see all of the rows in the underlying table that make up the 19,120 page views count.

I can then export this as a CSV or explore from this underlying data.

You can specify which fields are shown when someone clicks on view underlying dataโ€‹

By default, we show all of the dimensions from the Table. If you have fields from a joined table included in your results table, then we'll also show you all of the fields from the joined Table.

If you don't want all of the fields from your Table shown, then you can specify which fields you want users to see when they click on show underlying data for a field.

Check out the dimension or metric reference docs to see how to do this in your Table's .yml file.

Exploring data in a dashboardโ€‹

Dashboards allow you to arrange multiple charts that are related to each other into a single view.

You can interact with dashboards in your project in a few different ways. Learn more about it here.

Using "Explore from here" to explore from existing chartsโ€‹

One of the best ways of exploring data is using saved charts and charts in dashboards as the starting point to your data exploration. You can do this in Lightdash using the Explore from here button.

Explore from here gives you a copy of the same chart you can play around with. Any changes you make here will not affect the original chart - so you can Explore away without any worry of breaking things!

If you've never used the Explore View, then checkout this tutorial on using the Explore View in Lightdash.

Exploring from scratch with Tablesโ€‹

If you can't find any relevant saved charts or dashboards that answer your question, you can always explore your Tables from scratch.

To start an Explore view from scratch, just click on Explore --> Tables --> then select the table that you want to explore.

If you've never used the Explore View, then checkout this tutorial on using the Explore View in Lightdash.