Day-over-day absolute change

sql

SELECT day,
       revenue,
       revenue - LAG(revenue) OVER (ORDER BY day) AS revenue_change
FROM daily_revenue;

Explanation

A simple difference often matters more than the raw value.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Time-series patterns

Compute relative change versus previous row.

Open In sheetsqlsame section

Measure time since the prior event.

Open In sheetsqlsame section

Use LEAD for forward state checks.

Open In sheetsqlsame section

Pull the previous value in order.

Preview the next value in sequence.

Avoid NULL on the first row.