How it works
A reviewable workflow from signal to decision
Inspect samples first
Confirm that fields contain the expected values and types before aggregating them. This catches instrumentation mistakes early.
Choose the metric and grain
Select the aggregation, numeric field, time bucket, and filters that match the question. Keep incomplete newest buckets in mind.
Promote useful views
Add the result to a dashboard or alert when it becomes part of a recurring workflow. Use Query for multi-table and multi-CTE logic.
Capabilities
What is included
See the analysis
SQL recipes that use this capability
Calculate API Error Rate by Route
Use SQL to rank API routes by 5xx error rate while protecting the result from low-volume noise.
Open recipeMeasure Background Job Retry and Failure Rate
Find unreliable jobs by comparing successful runs, retries, failures, and tail duration.
Open recipeCalculate LLM Cost by Feature and Model
Attribute model spend, tokens, request volume, and cost per request to product features.
Open recipeStart with one production workflow
Use a focused prompt, send synthetic events, and verify the first useful query before expanding coverage.