Revenue · This year (2026)
€3.66M +21.7% vs same period 2025
Revenue totals €3.66M for this year (2026). August 2026 closed at €396K, −12.5% vs July.
RevenueThis year (2026)
Source: Sample store · orders
High confidence Sep still in progress
Ask your data.
Get the chart, the number and the SQL.
Plain-language analytics for Postgres, MySQL, Google Sheets and CSV. Read-only by construction, and always showing its work.
“Information that is imperfectly acquired is generally as imperfectly retained.”
Monthly revenue this year
Florence N. · just nowMonthly revenue this year
Follow up: “now by region”, “only France”…
Sample store
Ask the sample store — no account needed
Trusted by 2k+ operators who would rather ask than export
- Quillwork
- NORTHGATE
- kiln
- Fernhill & Co.
- Tidewater
- paloma.
- COBALTMERCANTILE
- Lumen/Loom
We show the SQL.
Every number comes with the exact query that produced it and the rows behind it. Analysts can edit it; everyone can read it.
ask · monthly revenue this year
POSTGRESQLGenerated from your question
SELECT date_trunc('month', orders.order_date)::date AS month, SUM(orders.total) AS revenueFROM ordersWHERE orders.status = 'paid' AND orders.order_date >= DATE '2026-01-01' AND orders.order_date < DATE '2026-09-28'GROUP BY date_trunc('month', orders.order_date)::dateORDER BY month ASCRevenue · This year (2026)
€3.66M+21.7%
✓one SELECT · no writes✓BEGIN READ ONLY31 ms9 rows
The right chart, by default.
Playfair picks the form from the question and the shape of the result, then follows the rules a careful analyst would. You can always switch.
chart engine · sample store
Why this chart
Nine months of one measure: a line shows the shape of the year, labelled at its end.
- Time on the x-axis → a line (applies)
- Categories → horizontal bars, sorted
- One value → a KPI with its comparison
- Bars start at zero
- One axis, never two (applies)
- Thousand separators, your currency (applies)
- Pie only for four parts or fewer
Ask why, not just what.PRO
Ask why a number moved. Playfair compares the two periods across every dimension it knows, ranks the contributors and shows the evidence.
ask · why analysis
Why did revenue drop in April?
April 2026 vs March 2026, across✓region✓category✓channel✓segment✓country
Revenue fell 10.1% in April vs March (−€43K). Electronics and Région Sud explain most of it.
- 1Electronicscategory−€43K · −34.9%€123.3K → €80.3K · 95% of the category change
- 2Région Sudregion−€21.6K · −46.4%€46.4K → €24.9K · 50% of the region change
Channel, segment and country moved roughly in line with the total, so they are not the cause.
Pin the evidence Alert me if it happens again
Dashboards that read like a report.
Pin any answer in one click. Tiles fill a 12-column grid, refresh on their own and share as a read-only link your client can open without an account.
dashboards · e-commerce overview
[DASHBOARD] Sample storeE-commerce overview
ShareRevenue
€104,953
▼ −3.7%vs previous weekOrders
558
▼ −7.6%vs previous weekAverage order value
€188.09
▲ +4.2%vs previous weekReturn rate
5.27%
▲ +0.9 ptsvs previous monthMonthly revenuePaid orders, complete months
Revenue by regionLast 12 months
- Île-de-France€1.4M
- Auvergne-Rhône-Alpes€640.9K
- Région Sud€533.3K
- Occitanie€428.9K
- Nouvelle-Aquitaine€427.1K
Anyone with the link can viewRead-only · no account needed · not indexedplayfair.asrar.example/d/Kq7vT2mXCopied
Read-only by construction.
A verified read-only role, a read-only transaction, a single-SELECT grammar and a timeout on every query. Your data never changes, and every statement lands in the query log.
query log · sample store
31 ms
- validate UPDATE orders SET status = 'refunded' WHERE id = 5203
- rejected before it reached the database: only a single SELECT is allowed
- connect playfair_reader@sample_store — read-only role, verified
- BEGIN READ ONLY
- SET LOCAL statement_timeout = '30s'
- EXPLAIN (FORMAT JSON) SELECT … — cost 1,842 · light
- SELECT date_trunc('month', orders.order_date)::date AS month, … LIMIT 10001
- ROLLBACK
- 9 rows in 31 ms · nothing written · saved to the query log
Connect what you already have.
A production database, the spreadsheet finance lives in, or a folder of exports. Credentials are encrypted at rest; files stay in the EU.
sources · asrar analytics
- Sample storePostgreSQL · 9 tables · p95 42 msHealthy
- Marketing budget 2026Google Sheets · 3 sheets · synced 12 min agoHealthy
- Supplier returnsCSV · XLSX · 2 files · 18,204 rowsHealthy
- Postgres
- MySQL
- Google Sheets
- CSV / XLSX
- APISOON
Reviewed by the pioneers.
The people who taught the world to read charts, asked what they think. Fictional, and affectionate.
“Finally, a coxcomb chart I didn’t have to draw by hand. It suggested a bar chart instead. It was right.”
“Found the pump in one question.”
“Six variables, one chart, zero dual axes. I have never felt so seen.”
“I asked for property values by county and got them by county, with the SQL to prove it. The exhibition would have taken a week, not a winter.”
“I invented the line, the bar and the pie chart. It took the world two hundred and forty years to add the query.”
“My timeline of two thousand lives took two years to engrave. Playfair drew revenue by month before my tea had cooled.”
Changelog
“A release every fortnight, each one smaller than the promise and bigger than the note.”
- 1.6.0Why analysis, with evidenceAsk “why did revenue drop in April?” and Playfair compares the two periods across every dimension it knows, ranks the contributors and shows the evidence behind each one.
- 1.5.2Anomaly nudgesPinned metrics are scanned every night. When one moves unexpectedly you get a calm note on Home and on the dashboard: “Revenue in Région Sud is −31% week over week — want to see why?”
- 1.5.0Scheduled reports as PDFSend a dashboard or a single answer every Monday at 8:00, in the recipient’s time zone, as a PDF or as inline charts in the email body.
Free to start. €49 when your team needs more.
One source and fifty questions a month cost nothing, forever. Pro adds governed metrics, schedules, alerts and branded sharing.
Free
€0forever, per workspaceOne source, fifty questions a month and a dashboard to share.
Start free- 1 data source (Postgres, MySQL, Sheets or CSV)
- 50 questions per month
- 2 members
- 1 dashboard with up to 8 tiles
Pro
MOST TEAMS€49per workspace / month · 5 seats, then €9 per seatGoverned metrics, schedules, alerts and branded sharing for teams.
Start free, upgrade in the app- Unlimited sources, questions (fair use 5,000/month), members and dashboards
- Refresh down to every 5 minutes
- Metrics, joins, hidden tables and semantic rules
- Corrections become rules; Why analysis and anomaly nudges
Custom
Let’s talkfor larger teams and agenciesEverything in Pro, with the paperwork and the help a bigger rollout needs.
Talk to Asrar- Everything in Pro
- Volume pricing for 25 seats and more
- Annual invoicing and purchase orders
- A signed DPA and a security review with our team
Every limit, side by side, on the pricing page.
[1869 · six variables · one chart]
Be like Minard.
He fit an army, a map, a winter and a calendar on one page. You only need one question.
After Charles Joseph Minard, Carte figurative des pertes successives en hommes de l’Armée Française dans la campagne de Russie 1812–1813, 1869.