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

Display your data as rows and columns. Tables work well when you want to compare many values or view raw data at one single place.

Note: Holistics Visualizations are also applicable for Cloud Pivot

Create Table

You can run Query to get the data table you need

General Settings

Drag and Drop Mode

After running a Query, you can pick fields or drag to Settings to display on your table

Filters

You can also create filters to make your report more meaningful which fit your expectation.

Styles

  • Aggregation
    • Total Row: Display total row of column
    • Average Row: Display average row of column
  • Misc
    • Pagination Size: Number of rows displayed per page of table
    • Row Number

Conditional Formatting

Allows you to specify customized cell colors based on cell values so you can quickly highlight important information in your report. You can either format individual cell or an entire row.

Single Color

Single Color Mode enables you to highlight cells with a certain color, depending on the cell's value.

Under section Conditional Formatting in tab STYLES in VIZ SETTINGS, choose Add Rule and select the column you want to format.

Result after Apply:

Then set condition under Format data if and Apply.

Color Scale

Color Scale Mode enables you to highlight column with a pattern of color, depending on the cell's value in that column. Cells are shaded with gradations of two or three colors that correspond to minimum, midpoint, and maximum thresholds.

In the popover, choose option Scale and set value for min, mid and max point, then Apply.

Result:

Color Scale

Color Scale