All Collections
FAQs
Why can't I see all the dates/columns in my pivoted table?
Why can't I see all the dates/columns in my pivoted table?

Pivoted table is cropped or not showing all of my results.

Katie Hindson avatar
Written by Katie Hindson
Updated over a week ago

When you pivot a table visualization in Lightdash (i.e. move a field from rows to columns), there is a limit of 60 columns in the pivoted table.

This means that if the dimension you've pivoted on (i.e. made into a column) has more than 60 distinct values, some data will be cropped from your pivoted table.

To avoid data being cropped, you should use filters to limit your data.

Did this answer your question?