Skip to main content
Gainsight Inc.

Report Settings & Advanced Options

This article focuses on the settings and advanced options available in the Report Builder. Before you get into this document, Gainsight recommends you to see How to Build Basic Reports article to understand the overview of the reporting functionality.

Aggregation

Once the fields have been added to Show Me, you will be able to choose aggregations. But, when you add a field to the By section, all the fields in Show Me are aggregated. The default aggregation is dependent on the field type. Text fields are automatically set to Count, and numeric fields are automatically set to Sum. Aggregation options for each data type include:

  • String/Text: Count, Count Distinct
  • Numeric: Count, Count Distinct, Min, Max, Avg, Sum
  • Boolean: Count
  • Date: Count, Count Distinct, Min, Max
  • DateTime: Count, Count Distinct, Min, Max

1. Aggregation.png

Set Column Calculations for Individual Columns

Add Column Calculated Function values (column aggregates) to tabular reports. In the report builder, for any numeric field in a tabular report, admins can set aggregations (Sum, Avg, Median) for individual columns.

To set column totals:

  1. Click the Settings/Gear icon on the field.
  2. Select the required aggregation from the Column calculations dropdown list. For example, you can select Sum, Average, or Median option (function) to appear in the column totals.

2. sfdc sum.png

 The column aggregate values will display in reports on Customer360, Gainsight Dashboards, and Success Snapshots; but are not available in CSV exports. Column totals work across all SFDC and MDA objects.

3. sfdc total.png

 Limitations:

  • Column Calculated Function values are not supported for Pivot reports that are visualized in Tabular format or any other chart visualization. Additionally, this feature is not supported when you export such reports using a CSV or Excel sheet.
  • Works only with Tabular reports.
  • Column Calculations is not dynamic with respect to Column Search. This means, the Column Total value either Sum or Average or Median will not update automatically if the column search is used to filter records.
  • For SFDC reports: displays the Column Calculated Function values up to 2000 records, whereas for MDA reports: displays Column Calculated Function values for records up to the limit that is set in the Tenant Management.
  • Column Totals don’t display Currency symbols in the exported reports.
  • Column Calculations on Currency fields will not work if Multi Currency is enabled in your org.

Row Grouping

Row Grouping in Reporting allows you to visually group the rows/records in a report by a dimension type field without aggregating all the other fields.

Row Grouping feature is visible when you click the gear icon on the dimension type fields added to Show Me and By.

You can enable row grouping on the following dimension data types:

  • String
  • Boolean
  • Picklist
  • Date

 To enable Row Grouping:

  1. Click on the existing report name to edit a report (or) Click + REPORT to create a new report.
  2. Add the required fields to Show Me or By.
  3. Click the Settings/Gear icon on the required dimension type field.
  4. Switch ON the Enable Row Grouping toggle button.
  5. Click RUN. You will see the visual hierarchy of the Account and its details grouped by Stage Name.

You can minimize and maximize the records in each group by clicking Minus (-) and Plus (+) icons respectively. You can use the - and + on top left to minimize all the groups in the table.

4. Business Use Case1.gif
 

Notes:

  • If you have enabled the Column total for any of the fields, you will see the Sum Total at the end of each group.
  • You can export the row grouped tables via Excel Exports, Success Snapshots and Dashboard PPT exports.
  • The number of records and the column totals displayed for each group are calculated for all the data in the group, and not just the records visible on the current page.
  • Assume, your records are displayed in two pages because of pagination.  Minimize action only minimizes the records on the current page. It does not bring the data forward from the next page.
  • Row grouped tabular reports are enabled with Server side search, where you can search for the records on the entire dataset in the Server side and not just from the data available on the UI/browser.

 Limitations:

  • You can apply row grouping only on one field at a time. Assume, you have applied row grouping on Field 1, and if you try applying again on Field 2, the row grouping applied on Field 1 automatically gets disabled.   
  • Once you enable row grouping, the pivot gets auto-disabled.
  • Row grouping is not supported in CSV exports.
  • Row grouped reports are not visible in Sally and Journey Orchestrator.

Pivot

Pivot feature is visible when you click the gear icon on the By fields, and you can see this option only when you have a minimum of two fields in the By section. You can apply pivot only on one field at a time. For more information on how to create Pivot tables within data that has been exported from Gainsight as an excel document, see the Microsoft tutorial Create a Pivot Table to analyze worksheet data.

You can pivot reports on the entire dataset from the server-side. There is no row limit for pivoted reports.

Note: The maximum number of pivoted columns visible in a report is 53.

Use Case: For example, when you create a report on Pageviews and pivot by Date. You will see that Date changes from Rows to Columns.

5. Pivot_Function.gif

Limitations:

  • Pivoting on SFDC objects, and the following MDA objects: Email Logs, Email Raw Events and Unsubscribed Emails will work as it was working previously.
  • You cannot Pivot the reports on which ranking is applied.
  • You cannot apply Ranking on pivoted reports.
  • You cannot apply Pivot on Row Grouped reports.
  • Column Search on the pivoted tabular reports will search for the records only from the browser, and other tabular reports will have server side.
  • Pivoted reports can no longer retain the column width preferences set by the admin/user.

Configure Drill Downs

To Configure Drill Down:

  1. Click on any point in a graph or widget to see a drill down view of the data associated with that data point.
  2. Once you are in the drill down page, click the three dots on the top right to see the list of available fields.
  3. You can add or remove the fields from the table. Select the required fields to add.
  4. Click Apply after you have made your selections.

6.png

 The drill down table will display your selections when users click on a data point on the graph. You can even control the order of the columns in a drill down view. For a quick video demo of how the drill down works, click here.

7. Drilldown_Order_of_Columns.gif

You can change the column order in the drill down reports and can persist the newly changed order, even after saving the report.

Table column Drill down.gif

You can download an Excel sheet report using the download icon. And, if you wish to save the changes you made, click Save.

Note: Reports containing more than tenant read limit number of records, will export in CSV format.

Ranking

Ranking would be used if you only want to include Top x or Bottom x records based on a particular field in the report.

Note: You can also sort the order for Tabular reports, even after applying Ranking.

To configure Ranking:

  1. Click the Settings/Gear icon.
  2. Select Ranking.
  3. Select the field that you’d like to rank your report on and set Top x or Bottom x based on your requirement and click Apply.

Click X on the upper right corner, to close the Ranking Window.

If you want to remove the previously applied "Ranking":

  1. Click the Settings/Gear icon.
  2. Select Ranking.
  3. Click CLEAR.

8. Ranking.gif

Other Settings

Export Scorecard Mass Edit Reports

Admins can now export scorecard mass edit reports as CSV files from the Report Builder and also from Dashboards.

Note: This feature was already available for the Account Scorecard (Scorecard 1.0) from the Gainsight Home page.

  1. Navigate to Administration > Report Builder.
  2. Select Scorecard Fact as the data source.
  3. Select Scorecard Mass Edit from the Report Type drop-down list.
  4. Click the Settings/Gear icon. You will see Export as CSV and Chart options.

9.png

  1. Click Export as CSV to export all of the selected features with/without group in the Show me section. The scorecard will be emailed to the logged-in user. Refer the following image to see a sample email with the .csv file attached.

10.png

  1. Click Chart options and Switch ON the Show comments toggle button, as shown below.

11. Chart options.png

 Note: You can view the scorecard mass edit reports only in tabular visualizations.

Normalize Graph: Line Charts

For time series data represented by a line chart, you have the ability to normalize the graph.

To enable the Normalize option:

  1. Click the Settings/Gear icon.
  2. Click Chart options.
  3. Switch ON the Normalize toggle button, as shown below.

12. Normalize Option.png

Before you turn ON the Normalize button, the line report displays the actual data points and their increases/decreases over time. After turning ON the Normalize button, the first value in the result represents the baseline or zero. Subsequent values represent the % of increase/decrease of the first value. Normalization allows you to figure out whether the values have been increasing/decreasing and by what % with reference to the first value.

13. Percentage Line Charts.gif

Show Percentages: Stacked Bar and Stacked Column Charts

For stacked bar and stacked column charts with 2 fields in the By section, you have the ability to show bars/columns in percentages.

To enable the Show Percentage option:

  1. Click the Settings/Gear icon.
  2. Click Chart options.
  3. Switch ON the Show Percentage toggle button, as shown below.

Stacked bar/column charts are very useful when you want to compare the ratios across different segments, like CSM, Region, or Quarter, etc.

Reporting Percentage.gif

Limitation: Stacked Bar/Column charts will not display the visual data points (Numbers) on the bar/column, if the percentage is below 15.

Cumulative Data

For Line, Area, Bar and Column charts, you have the ability to Show the Cumulative data. You can switch ON the Show Cumulative toggle button, if you want to visualize the cumulative data. This functionality adds the present data to the previous data. For example, if your monthly revenue for the month of October, 2018 was $20000 and the monthly revenue for the month of December, 2018 was $40000, the visualization chart displays the December, 2018 revenue as $60000.

15.png
 

To enable the Show Cumulative option:

  1. Click the Settings/Gear icon.
  2. Click Chart options.
  3. Switch ON the Show Cumulative toggle button, as shown below.

16. Cumulative Data.gif

View Milestones (Account and Relationships)

You can view milestones for an account or relationship. This feature is applicable for Line, Area, and Column charts.

To enable the Show Milestone option:

  1. Navigate to Administration > Report Builder.
  2. Click + REPORT.
  3. Select the source object.
  4. In the Show me section, add the required fields.
  5. In the By section, add a Date field. This step is mandatory to view the milestones. Alternatively, you can use the Summarized By option on the date field.
  6. For Accounts: Navigate to the report in the relevant C360 section. Users will be able to see a new option called Show Milestone.
  7. For Relationships: Navigate to the report in the relevant R360 section. Users will be able to see a new option called Show Milestone.
  8. Set the Show Milestone switch to ON.

17. Milestone .gif

Notes:

  • When you export a report, the milestones do not appear.
  • The option to view Milestones is available only on SFDC and MDA objects where account mapping is done. It will not show up on MDA objects where account mapping is not done.
  • Summarized By option will not be available in the Chart Options.

Summary Widget

Under Visualization type, there is a Widget option. Widgets work with 1 field in Show me, no fields in By, and when an aggregation is selected on the Show me field. You can save these reports and add them to a dashboard as a widget. You may display up to four widgets per horizontal row in Dashboard containers.

18. Widget.png

For example, you can generate a report on the Average Annual Revenue (ARR) for a particular account and use the Widget visualization, as shown in the following image. You can save widget reports and use them in a dashboard as a widget. Values in the widgets will change dynamically based on end-user filtering in Dashboards.

19.png

Notes:

  • You can export a dashboard that contains a widget report.
  • You cannot directly export a report that contains a widget. But, you can click the number on the widget and export the drilldown table.

Freeze First Column in Tabular Report

In Report Builder, the first column in a tabular report can be frozen, using the option Freeze First Column option. This feature is useful when you have a many fields in the Show me section, and while you scroll to the right, to view all of the columns in the report, and you want the first column to remain visible.

20. Freeze First Column.gif

Search Tabular Reports in all Consumption Areas

In all tabular reports, Gainsight provides support to search for any record within a report that has more than Tenant Read limit number of records. Lookup, SFDC id, longtext, or Picklist of SFDC results will be obtained from the entire dataset and not just from the data available on the UI. The search result will be displayed only upon pressing Enter after the search term is entered. (The following image shows the tooltip: ‘Press Enter to Search’ on UI). If the report has fewer than 2000 rows, the search results displayed will be narrowed as you type each letter.

Note: If there are more than 2000 records, the date picker may be used if you selected the Date/DateTime data type fields in the Show me or By section.

21.png

Sorting Tabular Reports in all Consumption Areas

In all tabular reports, Gainsight provides support to sort for records on the entire dataset and not just from the data available on the UI/browser.

Note: Server Side Sorting is also applicable for the reports in Drill Down view.

Limitation: Server Side Sorting is not applicable on Pivoted Reports.

Sort Server Side.gif

Column Width Persistence for Tables and Drill Down Reports

In all the tabular and drill down reports, Gainsight provides the support to customize/set the column width, as per your preference. The reports will retain the new column width preferences set by the admin/user even after saving the report.

Limitation: For pivoted reports, column width persistence is allowed only on the non-pivoted columns.

Below are sample snapshots from Report and Drill Down pages:

Report Page View

Report View.gif

Drill Down View

Drill Down View.gif

  • Was this article helpful?