Rolling Average helps smoothen numerical trends in data. Here’s how to calculate moving average in Redshift using SQL query.
MySQL doesn’t have function to calculate cumulative total. Here’s how to calculate running total in MySQL.
Weekly Active Users is a useful business metric to track. Here’s how to calculate weekly active users (WAU) in MySQL.
Sometimes you need to transpose columns to rows in a table. Here’s how to unpivot table in MySQL.
Sometimes you need to combine multiple row values into a single column. Here’s how to concatenate multiple rows into one column in MySQL.
Percentage Growth Week over Week is a useful metric for every business. Here’s how to calculate percentage growth week over week in MySQL.
Average Sales Per Week is a useful reporting metric. Here’s how to calculate average sales per week in MySQL.
There are 2 ways to add total row in MySQL using UNION ALL and ROLLUP. Here’s how to add total row in MySQL.
Percentage growth Month-over-month is a key performance indicator for every business. Here’s how to calculate percentage growth month by month in MySQL.
It’s easy to calculate percentage of columns in MySQL. Here’s how to calculate percentage of two columns in MySQL.