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

Table is the default visualization to display your result set when your query finished processing.

When to use Table?

Table works well when you want to have a feel of your raw data, for example, if you want to quickly compare several variables.

Create a Table

By default, when you finish running your query, the result set will be displayed with all columns included, and their display name defaults to the name you gave them in the query.

If you want to display only some columns and change their display name, you can drag the fields in Table fields area and modify their labels.

The table can be sorted along a column that was already dragged in. You can either specify the column and sort direction at Sort section in the Settings tab, or directly click on the column name.

Styling options

Aggregation

  • Total Row: Display a row with columns' totals
  • Average Row: Display a row with columns' averages

Misc

  • Pagination Size: Number of rows displayed per page of table
  • Row Number: Display the row number in front of table rows

Conditional Formatting

Conditional Formatting helps you color table cells based on their values just like in Excel. There are two formatting modes:

Single Color Mode

Single Color Mode highlights only cells that satisfy a certain condition with the color you chose. This is useful when you want to single out some special values.

Color Scale Mode

With Color Scale Mode, you can color cells in a color gradient. The color will depend on the cell's value in your specified data range.
Min and max points are required, and the mid point is optional.

Updated 4 months ago

Table


Suggested Edits are limited on API Reference Pages

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