Why can’t I see all my data on the Insights Table View report? A quick guide

Manuel Oliveira
Manuel Oliveira Admin Posts: 1,306 COMMUNITY MANAGER
1000 Comments 250 Likes 25 Answers Third Anniversary
edited November 27 in Sales CRM #1


Ever wondered why not all your data seems to show up in Pipedrive Insights’s Table View under your Insights reports? Don’t worry—it’s not a glitch but a clever design choice called pagination.

To keep your Insights reports running fast and smooth, the Table View loads data in batches of 100 items. As you scroll, the next batch automatically loads until you’ve reached the end of the list. This system ensures quick load times, even when your filters pull in thousands of records.

This functionality might feel familiar if you’re familiar with Pipedrive’s list view. However, the incremental loading process can sometimes create the illusion that some data is missing—especially if you don’t scroll all the way down. Let’s explore how you can ensure every piece of data is at your fingertips.

Pro Tips to Display All Your Data in Table View

1. Scroll to the End
The key to accessing all your data? Keep scrolling! Each scroll triggers the next batch of 100 items to load. If you stop mid-way, you might miss out on crucial information in the lower batches.

2. Export Your Data
Need to see everything at once without scrolling? Export your Table View data and open it in Excel or a similar tool. This gives you a complete overview without any interruptions.

3. Use More Specific Filters
Working with a massive dataset? Try refining your filters. Narrowing your search criteria reduces the total number of records, making viewing and analyzing your data easier without excessive scrolling.

4. Wait Before Sorting
Sorting before all the data is loaded can create an incomplete view. Always scroll to the bottom to load the entire dataset before applying sort options. This way, your sorting actions apply to the entire dataset, not just the visible portion.

Follow these tips, and you’ll ensure an accurate view of your data on Insights Table View every time. Happy scrolling, sorting, and analyzing! 🚀