|
Variable - Dropdown List SQL Options
|
A query with a variable feat a dropdown list widget with options from SQL
|
Sep 15, 2026
|
|
Variable - Dropdown List Custom Options
|
A query with a variable feat a dropdown list widget with static options
|
Sep 15, 2026
|
|
July 2025 Orders
|
A query with two variables with datepicker widgets and default values
|
Sep 15, 2026
|
|
Orders - Optional Filters
|
A query with [[optional]] clauses. Each filter disappears when its variable is empty
|
Sep 15, 2026
|
|
Customer Acquisition Analysis
|
A query demonstrating cross-schema joins, complex aggregations, date formatting, and conditional counting
|
Sep 15, 2026
|
|
Slow Query - Campaign Search
|
A query that ignores the indexes on purpose. Use the AI assistant to get optimization advice
|
Sep 15, 2026
|
|
Large Export - Order Items
|
A wide result set. Use it to try the streaming CSV export
|
Sep 15, 2026
|
|
Daily Revenue Trend
|
Daily revenue over the past 30 days for line chart visualization
|
Sep 15, 2026
|
|
Orders by Status
|
Distribution of orders by their current status
|
Sep 15, 2026
|
|
Top Products by Revenue
|
Top 8 products by revenue, narrowed by the customers' country and city when set
|
Sep 15, 2026
|
|
Customer Segments
|
Distribution of customers by segment tier, narrowed by country and city when set
|
Sep 15, 2026
|
|
Monthly Sales Trend
|
Monthly revenue and order trends over the past year
|
Sep 15, 2026
|
|
Customer Countries
|
The countries customers live in. Feeds the Country dashboard filter
|
Sep 15, 2026
|
|
Customer Cities
|
The cities of one country. Feeds the City filter, which depends on Country
|
Sep 15, 2026
|
|
Multi Search Path
|
A query joining two PG schemas via search_path
|
Sep 15, 2026
|
|
Revenue by Channel
|
Total revenue by customer acquisition channel, narrowed by country and city when set
|
Sep 15, 2026
|
|
Revenue by Day
|
Daily revenue between two dates. A dashboard date-range filter drives it
|
Sep 15, 2026
|
|
Audit - Schema Explorer Use
|
Schema discovery calls per kind and role, from the audit middleware
|
Sep 15, 2026
|
|
Support - Tickets by Priority
|
A variable widget on the SQLite source
|
Sep 15, 2026
|
|
Customers by Location
|
Customers per city, narrowed by the Country and City filters when set
|
Sep 15, 2026
|
|
Support - First Response by Team
|
Median-like view of the first response time per team
|
Sep 15, 2026
|
|
Audit - Query Activity by Role
|
Queries per role, from the audit middleware. The role comes from the Lotus actor
|
Sep 15, 2026
|
|
Support - Weekly Ticket Volume
|
Tickets per week over the last twelve weeks of the data
|
Sep 15, 2026
|
|
Audit - Recent Activity
|
The most recent demo activity. Change the window with the variable
|
Sep 15, 2026
|
|
Support - Satisfaction by Agent
|
Average customer rating per agent, for agents with rated tickets
|
Sep 15, 2026
|
|
Support - Tickets by Status
|
Ticket status share in the SQLite support-desk source
|
Sep 15, 2026
|