Build dashboards & reports in minutes

  • Features
  • Pricing
  • Blog
  • What is Ubiq
  • Free Trial

How to Concatenate Multiple Rows into One Column in MySQL

February 28, 2020May 17, 2020 Ubiq MySQL
concatenate multiple rows into one column 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.

Continue reading


How to Calculate Percentage Growth Week Over Week in MySQL

February 27, 2020May 17, 2020 Ubiq MySQL
calculate percentage growth week over week

Percentage Growth Week over Week is a useful metric for every business. Here’s how to calculate percentage growth week over week in MySQL.

Continue reading


How to Calculate Average Sales Per Week in MySQL

February 26, 2020May 17, 2020 Ubiq MySQL
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.

Continue reading


How to Add Total Row in MySQL

February 21, 2020August 19, 2020 Ubiq MySQL
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.

Continue reading


How to Calculate Percentage Growth Month By Month in MySQL

February 20, 2020May 17, 2020 Ubiq MySQL
percentage growth month by month

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.

Continue reading


How to Calculate Percentage of Two Columns in MySQL

February 19, 2020May 17, 2020 Ubiq MySQL
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.

Continue reading


How to Automate Pivot Table Queries in MySQL

February 18, 2020May 17, 2020 Ubiq MySQL
automate pivot table queries

Pivot Table is useful for data analysis. Here’s how to automate pivot table queries in MySQL to dynamically generate pivot tables.

Continue reading


How to Calculate Moving Average in MySQL

February 17, 2020May 17, 2020 Ubiq MySQL
calculate moving average mysql

Moving Average helps smoothen numerical trends in data. Here’s how to calculate moving average in MySQL using SQL query.

Continue reading


How to Calculate Cumulative Total in MySQL

February 14, 2020May 17, 2020 Ubiq MySQL
calculate cumulative total in mysql

There is no built-in function to calculate running total in MySQL. Here’s how to calculate cumulative total in MySQL

Continue reading


How to Transpose Rows to Columns Dynamically in MySQL

February 12, 2020May 17, 2020 Ubiq MySQL
transpose rows columns dynamically

There is no built-in function in MySQL to transpose rows to columns dynamically. Here’s how to transpose rows to columns dynamically using SQL query.

Continue reading


Page 20 of 24« First«...10...1819202122...»Last »

About Us



Ubiq is a business intelligence & reporting software. Build business dashboards, charts & reports in minutes. Get insights from data quickly. Try it for free!




Data Reporting
  • MySQL Reporting Tools
  • PostgreSQL Reporting Tools
  • Online Reporting Tools
  • Web Reporting Tools
  • Redshift BI Reporting
  • SQL Reporting Tools
Business Intelligence
  • BI Solution
  • BI Reporting Software
  • MySQL BI Reporting Tools
  • Self Service BI
  • SaaS BI
Data Visualization
  • Data Visualization Tools
  • Data Analysis Tools
  • Visual Analytics
  • MySQL Charts
  • MySQL Graph Generator
  • MySQL Report Builder
  • Online Report Generator
  • Redshift Data Visualization
Dashboards
  • Dashboard Builder
  • Dashboard Reporting Software
  • Dashboard Creator
  • KPI Dashboard Software
Quicklinks
  • Contact Us
  • Docs
  • Jobs
  • BI Blog
  • Database Blog
  • Tech Blog
Resources
  • Security
  • Privacy
  • T&C
  • Sitemap
dazzling Theme by Colorlib Powered by WordPress