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 ...