New: Cookbooks and AI ExplanationsStep-by-Step recipes to solve problems connected to Roadmaps and Cheat Sheets. Need more details? Use AI buttons for structured and simple explanations with concrete examples throughout the whole platform.Take a look
Your manager wants one number: did revenue grow or shrink compared with last month?
What you'll have at the end
A query showing this month's total beside last month's, with the percent change between them wherever one is actually computable
You need
A table of individual deals or sales, each row showing a closing date and an amount, spanning more than one calendar month.
Not covered
Comparing a partial, still-open current month against a prior month's finished total; this recipe assumes each month it reports on has already ended.
Leans on
Add a running total to a report
go there when the ask is accumulating the current month's own days into one climbing total, not comparing one whole month's total against the month before it
Smooth a noisy daily count into a 7-day rolling average
go there when daily counts are too jumpy to read as a line, not for a single month-over-month percentage a manager checks once
Checked 26 Aug 2026
Part of the SQL for Data Analysis cookbook