Holistics Docs - End-to-End Business Intelligence Platform

The Holistics Documentation

Welcome to the Holistics Documentation. You'll find comprehensive guides and documentation to help you start working with Holistics as quickly as possible, as well as support if you get stuck. Let's jump right in!

Guides    Get Started

Pivot Table

What is Pivot Table?

Pivot tables (similar to Excel Pivot Table) are an effective visualization that allows you to present and summarize your data through dragging and dropping the columns and rows from a result set without changing a chart's SQL.

When to use Pivot Table?

The pivot table is necessary when you want to summarize a large amount of data in a single table (report), and then want to reorganize them to see different subtotals.

How To Build: Pivot Table

  1. Run your report SQL query to return all the needed dimensions and measures field columns.
  2. Select Pivot Table on the right-side panel
  1. Drag and Drop fields to Rows, Columns and Values in Pivot Settings

Some common use-cases:

Number of Male and Female by Countries and Cities

The changes in Price of products through times