...

/

Computing Weekly Changes

Computing Weekly Changes

Learn to compute changes for various time durations in PostgreSQL.

We'll cover the following...

Let’s assume that the analytics department now wants us to add a weekly difference for each day of the result. More specifically, we want to add a column with the evolution as a percentage of the dollars column between the day of the value and the same day of the previous week.

Use case: Computing weekly changes

We’re taking the “week over week percentage difference” example because it’s a classic analytics need, though perhaps mostly in ...