Assistant
Ask about your data, documents and work
Summarise our third quarter for the board. Keep it to one page.
09:12Here is a one-page summary of the third quarter, July to September, from the books, the store, the sales pipeline and the people data in your workspace:
- Income came to $1.14M, down 18.8% on the second quarter, which closed more platform deals (33 against 30).
- The store took 1,129 orders worth $171.7K and won 374 new customers.
- Sales closed 30 platform deals worth $880.6K.
- Spending was $1.19M, so the quarter ended $47.3K down, with $1.29M in the bank.
- The team is 40 people; 1 person joined in the quarter.
Risks to watch: 10 open deals are due to close in November, and the store has to carry the Black Friday weeks. Shall I add a chart of income by month?
09:13Yes, and give me the SQL behind the revenue number.
09:14Revenue by month, from the invoices table:
select date_trunc('month', paid_at) as month,
sum(total) as revenue
from invoices
where paid_at >= '2026-07-01'
group by 1
order by 1;09:14Show me churn by plan for the last six months, as SQL.
16:02Here is the query; it counts cancelled subscriptions over active ones, per plan and month:
select plan, date_trunc('month', cancelled_at) as month,
count(*) filter (where cancelled_at is not null) * 1.0 / count(*) as churn
from subscriptions
group by 1, 2
order by 2, 1;16:02Write a short launch email for release 4.2.
11:20Subject: Vitreo 4.2 is here. Checkout is 38% faster, search finds what you mean, and twelve colour themes make it yours. Update today.
11:21Five interview questions for a product designer.
14:05Here are five:
- Walk me through a decision you changed after research.
- How do you work with engineers on a deadline?
- Show me a design you would redo, and why.
- How do you design for someone using a screen reader?
- What does a calm interface mean to you?
Three ideas to make our pricing page clearer.
10:12Lead with the plan most teams pick, show the yearly saving in money rather than percent, and answer the three questions sales hears most right under the table.
10:13Explain the burn-down chart on the projects page.
09:40It shows the work left each day of the sprint. The straight line is the plan; the other is what is really left. Above the plan line means the sprint is behind.
09:41Translate the 4.2 release notes into Swedish.
15:30Vitreo 4.2: kassan är 38 % snabbare, sökningen förstår vad du menar och tolv färgteman gör den till din.
15:31