Custom Date Range Comparison
Compare any two time periods to measure the impact of changes.
“Compare total revenue, average order value, and new customers between Jan 1-Mar 31 vs Apr 1-Jun 30”
Expected Insight
Side-by-side comparison of the selected metrics for both date ranges with absolute and percentage differences.
Prompt variations
Try these follow-up prompts to explore your data further.
“Export this as a CSV”
“Show a chart instead of a table”
“Add a date range filter”
“Include all columns from the table”
Tips for best results
Be specific with time ranges
Instead of "recently," say "in the last 30 days" or "this quarter." Specific dates produce more accurate results.
Name your dimensions
Say "by region" or "grouped by sales rep" to get the breakdowns you need. The AI works best with explicit grouping.
Ask for the format you want
Request "as a bar chart," "in a table," or "as a percentage" to get results in the format that is most useful to you.
Use follow-up questions
After your first answer, drill deeper with "Why?" or "Break this down further." The AI remembers context.
Related prompts
Database Health Check
Quick diagnostic of your database for common data quality issues.
Year-over-Year Growth Summary
Compare key metrics across years to spot long-term trends.
Data Export for Spreadsheet
Pull structured data ready for analysis in Excel or Google Sheets.
Top Customers by Revenue
Identify your highest-value customers for the current quarter.
Try this prompt in AI for Database
Connect your database and get answers in seconds. No SQL required.