If you need to transpose rows as columns or pivot table, then you need to do it via SQL query. Here’s how to display row values as columns in MySQL.
How to Display Row Values as Columns in MySQL
MySQL
How to Calculate Running Total in MySQL
MySQL doesn’t have function to calculate cumulative total. Here’s how to calculate running total in MySQL.
How to Calculate Weekly Active Users (WAU) in MySQL
Weekly Active Users is a useful business metric to track. Here’s how to calculate weekly active users (WAU) in MySQL.
How to Unpivot Table in MySQL
How to Concatenate Multiple Rows into One Column 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.
How to Calculate Percentage Growth Week Over Week 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.
How to Calculate Average Sales Per Week in MySQL
Average Sales Per Week is a useful reporting metric. Here’s how to calculate average sales per week in MySQL.
How to Add Total Row 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.
How to Calculate Percentage Growth Month By Month 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.
How to Calculate Percentage of Two Columns in MySQL
It’s easy to calculate percentage of columns in MySQL. Here’s how to calculate percentage of two columns in MySQL.