Modifying Row and Column Limits

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 so low, a good part of the visualization is just empty space, and largely meaningless.

The easiest way to fix this problem is to limit the number of records (rows) returned by the query; as a result, 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 tells you that there are more records that could have been returned but, due to the row limitation, were not 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.