Skip to main content
Gainsight Inc.

Configure Column Line Visualization Report (Horizon Analytics)

  1. Last updated
  2. Save as PDF 
IMPORTANT - Articles Impacted due to 6.34 October NXT Release

Due to the v6.34 October, 2022 release, this article has been impacted. Steps, images, and playable GIFs in this article will soon be updated to reflect the latest changes.

For more information about the latest UI changes, click here.

 

​Introduction

The Column Line visualization is enabled only when a minimum of 2 Fields are added in Show Me and a maximum of 1 Field in Group By.

The Column Line visualization can be created in the combinations of 2x1, 3x1, 4x1, 5x1, and 6x1 Fields for Show Me and Group By, respectively.

Note: Column Line visualization supports a maximum of 6 Fields in Show Me.

Configure Column Line Visualization

To configure the Column Line Visualization:

  1. Navigate to Administration > Report Builder (BETA).
  2. Click on the existing report to edit the report or click Create Report to create a new report.
  3. Add the Fields required in the Show Me and Group By sections.
    Notes: 
  • A minimum of 2 Fields are required in Show Me, and a maximum of 1 Field is needed in Group By to enable Column Visualization.
  • Column Line Visualization is not enabled for more than 1 Field in Group By section.

For more information on creating new reports, refer to the How to Build Basic Reports article in the Additional Resources section at the end of this article.

  1. From the right pane of visualizations, select the Column Line chart. The data in the report is displayed in a Column Line chart.
    Note: By default, the last field in the Show Me section is assigned as Line and other fields as columns. Admins can change the representation of the fields as Lines in the settings sections of the report.

  1. Click the Settings/Gear icon on the report. The Chart Settings page appears.
  2. Click the Select Lines dropdown section.
  3. From the dropdown list of Select Fields, select the required field to be represented as Lines.
    Notes: 
  • Only 1 Field can be selected at a time for representation as Line.
  • To enable Column Line visualization, you must have at least one column and one line.

  1. Click Apply.

In Column Line visualization, the Dual Y-axis is enabled automatically, all the Lines corresponding to the Y-axis are on the right side, and all the Columns corresponding to the Y-axis are on the left side.

To enable or disable the Dual Y-axis:

  1. Click the Settings/Gear icon on the report. The Chart Settings page appears.
  2. Click Chart Options.
  3. Toggle the Show Dual Y-axis switch.

1. Dual y Axis.png

For more information on the Chart settings, refer to the Chart Setting and Chart Editor article in the Additional Resources section at the end of this article.