We're excited to continue enhancing the customer experience for both data analysts and their colleagues who rely on reports in Google Sheets. Following the announcement of filters, and sorting, today we introduce a new feature – the Query 'Limit' option with a default value for all new reports. This enhancement in our Query editor simplifies how users manage data limits.
What is the Query 'Limit' Option?
The Query 'Limit' Option allows you to set a default data limit directly from the Query editor, without altering the SQL code. Similar to SQL's 'LIMIT' clause, this feature enables easy adjustment of data retrieval limits for each report.
Key Benefits
- Flexibility: Define a default limit (e.g., 200,000 rows) in the Query settings, automatically applied to all new reports.
- Ease of Use: Adjust the limit directly from the Extension panel in Google Sheets without needing SQL edits.
- Collaboration: Team members can independently modify limits for their reports, enhancing workflow customization without impacting others.
- Read more details and examples of the default Query ‘Limit’ option
Why It Matters
- Efficiency: Save time by avoiding manual SQL adjustments for each report.
- Accuracy: Standardize data limits across reports for consistency and reliable insights.
- Accessibility: Simple controls enable users of all levels to leverage powerful data management features.
- Read more Tip & Tricks on how to cover more reports with the same Query
From today, this feature is available in the extension interface. Discover how this feature can transform your reporting today! Open your Google Sheets documents and Extension panel to create new queries with adjustable data limits.
Thank you for choosing OWOX BI!
0 Comments