![WellDatabase-Rect-1000x159-1.png]](https://support.welldatabase.com/hs-fs/hubfs/WellDatabase-Rect-1000x159-1.png?height=40&name=WellDatabase-Rect-1000x159-1.png){kind=small}
How do row limits affect Analytics?
Analytics visualizations—including tables, pivot tables, and charts—are subject to subscription-based row limits. Understanding these limits can help explain why Analytics may display fewer results than the List or Overview.
Analytics are designed to help you summarize and visualize your search results. When working with large datasets, Analytics displays up to the maximum number of rows allowed by your subscription. This allows tables, pivot tables, and charts to remain responsive while providing meaningful insights into your data.
Analytics Row Limits
The maximum number of rows displayed in Analytics depends on your subscription level.
| Subscription | Maximum Analytics Rows |
|---|---|
| Essential | 100 |
| Plus | 250 |
| Pro | 1,000 |
How It Works
Analytics row limits apply to all Analytics visualizations, including:
-
Tables
-
Pivot Tables
-
Charts
Each visualization is generated from the same Analytics dataset and follows the same subscription-based row limits.
Common Scenarios
Row limits are most noticeable when grouping or pivoting by fields with a large number of unique values, such as:
- Well Name
- Lease
- Operator
- Any other field with many unique values
For example, if your search returns thousands of wells with several hundred unique operators, tables will display up to the maximum number of rows included with your subscription.
Understanding Differences Between Analytics and Search Results
The List and Overview display the complete results returned by your search.
Analytics visualizations display up to the maximum number of rows allowed by your subscription. If the row limit is reached, tables, pivot tables, and charts may display fewer total well than the results shown in the List or Overview.
This behavior does not affect your underlying search results. It only affects how many rows are included in the Analytics visualization.
Recommended Workflow
If your Analytics visualization reaches the row limit, consider the following recommendations:
-
Apply additional filters to reduce the number of unique rows returned.
-
Analyze data in smaller groups, such as grouping analytics by county, state, well status.
Frequently Asked Questions
Q: Do row limits affect my search results?
A: No. Row limits only apply to Analytics visualizations. Your search results remain unchanged.
Q: Do row limits affect tables, pivot tables, and charts?
A: Yes. All Analytics visualizations—including tables, pivot tables, and charts—follow the same subscription-based row limits.
Q: Why don't my counts match between Analytics and the List or Overview?
A: If the Analytics row limit has been reached, Analytics displays only the maximum number of rows allowed by your subscription, while the List and Overview continue to display all matching search results.
Q: Why doesn't my pivot table show every operator?
A: Pivot tables are subject to the same Analytics row limits as other Analytics visualizations. When pivoting by fields with many unique values, such as Operator, the visualization may reach the maximum number of rows allowed by your subscription.
Q: Can I increase the Analytics row limit?
A: Analytics row limits are determined by your subscription level. Essential displays up to 100 rows, Plus displays up to 250 rows, and Pro displays up to 1,000 rows.
Explore additional articles by searching the topics on the left. If you have any questions, feel free to email support@welldatabase.com.