Data
Answer a question from data
Answer a question from a database or table: read the schema, write a read-only query, sanity-check the result, and answer with the query shown.
Add in the app
Data · For your bots
What changed in the numbers
Check a set of numbers for what changed: compare to the usual range, find the biggest moves, and say which ones are real.
In Lobstack: Skills › Library › Add
Download LobstackWhen to use it
A daily or weekly look at signups, revenue, spend, traffic or errors, or someone asks why a number looks off.
What your bot will do
- 01
Pull the series for the period and the same span before it, from the table, database or file the person named. Say the source and the range.
- 02
Work out the usual range from the earlier span (median and spread), and flag values outside it. Run the arithmetic; do not estimate it.
- 03
For each flag, look for the plain cause first: a missing day, a changed definition, a holiday, one large customer, a release on that date.
- 04
Report the moves that are real, biggest first, each with the number, the usual range and the likely cause, marked as checked or as a guess.
- 05
Say what you did not check.
A chart helps only if it shows the usual range. Flat is a finding too.
The file
---name: metric-anomaly-checkdescription: "Check a set of numbers for what changed: compare to the usual range, find the biggest moves, and say which ones are real."metadata: title: "What changed in the numbers" category: data tags: [data, analysis]--- ## When to use this A daily or weekly look at signups, revenue, spend, traffic or errors, orsomeone asks why a number looks off. ## How 1. Pull the series for the period and the same span before it, from the table, database or file the person named. Say the source and the range.2. Work out the usual range from the earlier span (median and spread), and flag values outside it. Run the arithmetic; do not estimate it.3. For each flag, look for the plain cause first: a missing day, a changed definition, a holiday, one large customer, a release on that date.4. Report the moves that are real, biggest first, each with the number, the usual range and the likely cause, marked as checked or as a guess.5. Say what you did not check. A chart helps only if it shows the usual range. Flat is a finding too.