Holistics Docs - End-to-End Business Intelligence Platform

Holistics Documentation

Welcome to the Holistics Documentation page. 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!

Get Started

Pivot Table

Pivot Table is a visualization type that aggregates data by combinations of dimensions and measures. Pivoting data is a useful and essential technique in the business world, so we have written a dedicated blog post explaining What is a Pivot Table and how to use it.

When to use Pivot Table?

Pivot Table is useful when you still want to present your data in table form, but with more meaningful aggregations like sum, average, min, max...

Create a Pivot Table

It is very easy to create Pivot Table in Holistics. In Rows and Columns fields, select the dimensions that you want to aggregate your data on. In Values field, select the column that you want to aggregate. Note that the Values field always contains an aggregation.

Sort

There are two ways to sort data in Pivot Table:

  • Go to Pivot Table → Add field to sort, and select sort order on Viz Settings → Get Result; or
  • Click on Angle icon on Pivot Header

Note that you are only able to sort fields that are using in Pivot Table.

Styling options

Display

  • Pagination Size: Number of rows displayed per page of table
  • Display empty cell as 0: Enable it if you want to convert your empty cell to zero
  • Row Height: Clip (single-line) or wrap (multiple-line) long-content cell

Conditional Formatting

Conditional Formatting in Pivot Table works the same as in Table.

Aggregation

  • Grand Total:
    • Row Total: the sum of all values on a row
    • Column Total: The sum of all values on a column
  • Sub Total: Total of values by some dimensions

Updated 26 days ago

Pivot Table


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.