Your First Query
Learn how to ask your first question and get insights from your data in seconds.
📝 Before You Start
Make sure you have:
- ✅ Logged into Datix xAgents
- ✅ At least one data source connected
- ✅ At least one agent configured
- ✅ Assigned to an agent (if you're not an admin)
🎯 Navigate to Chat
- Click "Chat" in the left sidebar
- Select an agent from the dropdown (if you have access to multiple)
- The chat interface will open
💬 Ask a Question
Simple Questions
Type your question in natural language. Examples:
What are my total sales this month?
Show me the top 10 customers by revenue
How many active users do we have?
What's the average order value?
Advanced Questions
For more complex analysis:
Compare sales by region for Q4 2025 vs Q4 2024
Show me customer churn rate by cohort for the last 6 months
What's the conversion rate from trial to paid in the last quarter?
🤖 How It Works
When you submit a question:
- AI Processing: The agent analyzes your question
- SQL Generation: Creates an optimized SQL query
- Query Execution: Runs against your database
- Results Display: Shows data in a table format
- Visualizations: Auto-generates charts when appropriate
- Follow-ups: Suggests related questions
📊 Understanding Results
Data Table
- Headers: Column names from your database
- Sorting: Click any header to sort
- Pagination: For large result sets
- Export: Download as CSV
SQL Query
Click "View SQL" to see the generated query:
SELECT
customer_name,
SUM(order_total) as total_revenue
FROM orders o
JOIN customers c ON o.customer_id = c.id
WHERE order_date >= '2025-01-01'
GROUP BY customer_name
ORDER BY total_revenue DESC
LIMIT 10;
💡 Tips for Better Questions
Be Specific
❌ "Show me data"
✅ "Show me sales data for January 2026"
Use Time Periods
❌ "What are our sales?"
✅ "What are our sales this quarter?"
Specify Metrics
❌ "How are we doing?"
✅ "What's our revenue growth rate year over year?"
Include Filters
❌ "Show customers"
✅ "Show customers who made a purchase in the last 30 days"
📥 Exporting Data
To download results:
- Hover over the results table
- Click the Export button
- Choose format (CSV recommended)
- File downloads to your browser
🕐 Query History
All your queries are saved:
- Click "Query History" in the sidebar
- See all past queries with execution time and results
- Click any query to view full results
- Re-run previous queries instantly
⚠️ Common Issues
You need to connect a data source first.
Ask your admin to assign an agent to you.
The agent doesn't have access to that table. Contact your admin.
🚀 Next Steps
- Create Query Templates for common questions
- Explore Analytics to see usage patterns
- Learn more about natural language queries