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

Line Chart (Legacy)

Line

Line charts are useful when you want to visualise how your data is trending over time. Line charts can be used to visualize a single data series, or multiple, within the same chart.

How to Build: Single series line chart

Line

For a single series line chart, run your SQL query such that it returns 2 columns of values. The 2 columns of values are required to generate the x and y-axes of the chart. Typically, the x-axis values would be a collection of ordered values, such as date values. Specify the data types within the 'Format Columns' section of the Report Editor. In this example, the 'Date' column uses the date data type, and the 'Customer Signups' column uses the number data type.

Line

Access the Visualization Editor at the bottom of the Report Editor screen, and select the 'Line' chart option button. Under 'General', specify which column will be on the x-axis, such as the 'Date' column, and the column to be on the y-axis, which in this case are the number data values of the 'Customer Signups' column.

Line

How to Build: Multiple series line chart

Line

For a multiple series line chart, run your SQL query such that it returns at least 3 columns of values. All the columns should share one common x-axis, such as date values. In this example, we have 7 columns of values, with 1 date column and 6 country columns for broadcasts. This table of values was actually tabulated using the Holistics 'Quick pivot' feature under the 'Data Settings' section of the Report Editor, for a fast and easy transformation of the data across a column dimension. We specify the data types within the 'Format Columns' section of the Report Editor. In this example, the 'Date' column uses the date data type, the 'Country' column uses the string data type for its values, and the 'Broadcasts' column uses the number data type. Selecting the 'Quick Pivot' transform feature then produced this data table.

Line

Access the Visualization Editor at the bottom of the Report Editor screen, and select the 'Line' chart option button. Under 'General', specify which column will be on the x-axis, such as the 'Date' column. As this table of data was built using the 'Quick Pivot' feature, there is no need to specify the columns for the y-axis. Holistics will then plot the remaining column series of data as multiple line series on the chart, in relation to the x-axis values.

Line