Modify data table row and column limits

📘

This article applies to the following Customer Insights roles: Developer

By default, queries return the first 500 records that meet the query requirements. That occasionally results in visualizations like this one:

Is that a useful visualization? Well, part of it is. But because the highest value is so high and most of the other values are so low, a good part of the visualization is just empty space.

The easiest way to fix this problem is to limit the number of records (rows) returned by the query; that limits the number of columns displayed in the visualization. To limit the number of rows, go to the Data Section and type a new value in the Row Limit field. For example, this limits the number of returned rows to 7:

That gives us a very different visualization:

By the way, if you place a limit on rows or columns you might see a message similar to this when your run your query:

This message simply tells you that there are more records that could have been returned but, due to the row limitation, those records weren't returned.

If your query includes a pivot, you can place a similar limit on the number of columns displayed:

By default, Customer Insights has a row limit of 5,000 and a suggested limit of 50 columns.