Why can't I see all my data when I pivot a table?

Pivoted tables in Lightdash are limited to 60 columns. If the dimension you're pivoting has more than 60 distinct values, some data will be cut off.

To fix this, use filters to limit your data before pivoting.

For example, if you're pivoting by date and have more than 60 days of data, filter to a specific date range first.