Skip to main content
All CollectionsFAQs
Why is the "view underlying data" not showing me all of my data?
Why is the "view underlying data" not showing me all of my data?

Show underlying data cropped/not showing all values.

Katie Hindson avatar
Written by Katie Hindson
Updated over 9 months ago

I think my underlying data isn't showing all of my data.

The view underlying data function in Lightdash lets you see the values that make up your metrics/aggregations.

By default, the table that you're shown when you click view underlying data is limited to the first 500 rows. If your underlying data is more than 500 rows, then some data will be cropped from the table.

If you want to see more results from your underlying data, you can hit export CSV to export the table with an increased cell limit.

Did this answer your question?