How to Build Basic Reports

Select Object and Fields

To select Object and Fields:

1. From the Select Object dropdown list, select the Data Source using one of the following tabs:
   1. Frequently Used: Displays the list of objects that are frequently used by the customers and Gainisght recommended objects.
   2. All Objects: Displays the list of all available objects from the source.
      Note: For new tenants, all 10 objects are recommended by Gainsight in the Frequently Used Object tab until the first report is created.
2. Select or search the required object. All the fields from the selected object apper in the Fields section.
3. Enter the field name in the Fields Search bar or scroll down to view  the fields.
4. Drag and drop the required fields from the Fields section to Show Me and Group By.

Most commonly used objects:

• Company: General customer information, including onboarding stage, number of employees, ARR, Current Score, Industry, Company Type, Renewal Date, Original Contract Date, etc.
• Note: Reports built for aggregated fields from Data Designer objects, only the Global Currency is honored.
• Activity Timeline: Subject, Activity Type Name, Activity ID, Activity Date, etc.
• Company Person: General attributes of the person in association, including the status of a person, GSID, Role, etc.
• NPS Survey Response: Responded Date, Score Type, NPS Score, etc.
• Call to Action: For customized CTA reason/status/type reporting (Call to Action ID is a unique identifier for each CTA)
• For detailed description on all Objects, refer to the Gainsight Object Glossary article.

Show Me

The following options are available for the fields added to Show Me:

• Click the Settings/Gear icon next to the field label to update Field Display Name, Decimal Places, Column Calculations and Numeric Summarization. 
• Hover on the field to see the changes made on the field. 
• For Aggregated Reports, select the required Aggregation by clicking the Aggregation  type dropdown list. 
• Click X, to remove a field from Show Me.

Notes:

• Based on object selection, you will see all of the fields and lookup fields associated with that object.
• Fields added to Show Me can be reordered by dragging and dropping.

Group By

To slice and dice or segment the data in a report, add a field to Group By. A maximum of 10 fields can be added to Group By. A field will have to be considered Groupable by Salesforce and in MDA in order to use it in the Group By section. If a field is not added to the Group By section, you can only view the data in a table.

You can click the Settings/Gear icon next to the field label, to perform the following operations:

• Change the Field Display Name by providing a new name in the textbox. The Field Display Name is the label that appears on your report.
• Activate Pivot reports by turning on the toggle. This toggle is only displayed if there are two or more fields under the Group By section. To know more about Pivot reports, refer to the Pivot section.
• Rename the chart labels in your reports using the Configure Aliases option. To know more about creating aliases, refer to the Configure Aliases section.
• Activate the Row Grouping option. To know more about Row Grouping, refer to the Row grouping section.

• Summarize your data by date ranges. To know more about this option, refer to the Summarize By section.

Notes:

• Once you add a field to the Group By section, all the fields in Show Me will get aggregated.
• Drag and drop the fields from Show Me to Group By.
• Hover on the field to view the details.
• The following data types cannot be added to the Group By section:
  • Rich Text Area
  • Multipicklist
  • Measures (Number, Currency, and Percentage, etc.)
  • Address
  • URL

• Group By section now supports multi-select picklist data types. This allows you to perform group-by functionality on a multi-select picklist.

Add Formula Field

Use Formula Fields in reporting to instantly create a formula field on Gainsight objects, based on your business needs. The Formula Fields created in a report can be consumed in other functionalities of Gainsight, including Dashboards, C360/R360, Success Snapshots, etc. 

Currently, in Gainsight, you can also create Formula Fields from Rules Engine and Data Management, and use them in reports.

Note: You can also apply Filters using the newly created Formula Fields.

For more information on how to create a Formula Field, refer to the Formula Fields in Reporting article.

 

Run Report

To Run a Report, click Run Report or click on any available visualization icon on the right side. If you click Run Report, by default data is displayed in a table type visualization.

The following options are available in the Tabular Reports:

• Search: Type in the keyword and search for any record within the report, and you can also apply search filters based on your requirement.
• Sort: you can sort for any column in the report. 
  Notes:
  • Only the records displayed on the current page will be sorted when sorting by a picklist. You can use the Pagination option to determine the number of records that are visible on each page.
  • In pivoted reports, only the records on the current page are sorted when sorting is applied on any of the fields under Show me.
• Maximize: View the tabular report in a full-screen view by clicking the Maximize icon.
• Settings: Click the Settings/Gear icon on the upper left corner of the report to apply the Grid Settings. In Grid Settings, you can configure the following:
• Grid Options: Enable or disable the First Column Freeze and/or Text Wrap.
• Ranking & Sorting: Configure the Ranking and Sorting options as required. For more information on Ranking and Sorting, refer to the Advanced Report Settings article.
• Refresh: clears all the applied sort and search filters.
• Pagination: If there are too many records, use the pagination tool to navigate through different pages and view multiple records, in a set of 50, 100 or 200 on a single page, based on your selection.

Visualization Types

Visualization types are dependent on the number of fields added to Show Me and Group By. To select a visualization, hover to the right of the screen and select the required visualization type from the following options.

• Table   
• Pie
• Bar
• Column
• Line
• Area
• Stacked Bar
• Stacked Column
• Scatter
• Bubble
• Column Line
  Note: For more information refer to Column Line
• Heat Map
• Packed Bubble
• KPI Widget
  Note: For more information refer to  KPI Widget
• Donut:
• Funnel
• Gauge

Notes:

• The visualization types: Column Line, Line, and Area chart are consistently presented in ascending order to improve chart readability. Even if the user applies the DESC (Descending) filter in Chart Settings, causing the system to sort the underlying data in descending order, the chart continues to visually display the data in ascending order, when the data is grouped by a Date or Date time field.

  For example, consider the dataset with records 6/28/2021, 8/24/2021, 3/14/2022, and 10/18/2023. When applying the DESC filter, the underlying data is sorted in descending order as 10/18/2023, 3/14/2022, 8/24/2021, 6/28/2021. However, despite the descending sorting, the chart visually displays the data as 6/28/2021, 8/24/2021, 3/14/2022, 10/18/2023. In terms of appearance, the data seems to progress from left to right, creating a visual impression of ascending order.

• The visualization types: Bar Chart, Column Chart, Line Chart, Area Chart, Column Line Chart, and Stack Chart show any unavailable data in the object as Data Not Available. It helps users to identify gaps in the report due to a lack of data availability and take the necessary actions.

• Reports support missing data points for the picklist data type. To use this Missing Data Points functionality, turn on the Enable Missing Data Points toggle in the Chart Settings.

• Apart from Table type visualization, you can see the Chart Editor option for all types of visualizations. Chart Settings differ from one type of visualization to another. For more information on Chart Editor and Chart Settings, refer to the Chart Settings and Chart Editor article.

 

• Users can drill down and analyze data for all the gauge widgets in a Gauge report.  Any changes made to one of the widgets will reflect in all other gauge widgets in the report. For example, if new fields are added to one gauge widget, the same fields are also added to all other gauge widgets in the report. 
• The following image describes the combination of Show Me and Group By fields required in a report, to generate each of the above mentioned visualizations.

Note: Graphical reports honor the custom colors, colors configured on Gainsight picklist items, and scorecard colors.

Filters

In the Report Builder, you can see two types of filters:

• Add Filters on Fields
• Add Filters on Measures

New, Save, Clone, Share Reports and Download Data

In the Report Builder, the following options are available:

 

1. New Report: Clicking New Report allows you to create a new report. However, if you have already started building a report, you will lose the settings if you click New Report. 
2. Save Report: Clicking SAVE saves the report to the report Repository.

  To save a new report:

1. Click Save Report.

2. Enter the Report Name. This is the name that appears in the Repository, as well as in any menus or screens where the report is displayed.
   Limitation: To create multiple reports with the same report name, use some additional prefix or suffix text and then save the report. 

3. Select Folder: Select the folder in which you want to add the report, if the folder is already created in the Reports Listing page (or) By default, the report will be saved in the Uncategorized folder.

4. Enter the Description of the report, if required.

5. Select the Allow addition of new records check box, to add Add and Edit record functionality to the new reports.
   
   Note: If the Enable Add Record toggle is turned on in the General Settings, the Allow addition of new records checkbox is automatically checked. However, if the toggle is turned off in General Settings, the checkbox appears disabled. You can uncheck this box if the Add and Edit record functionality is not needed in this report.

6. (Optional) Select the Mark as Quick Insights check box.

7. Click Save.

8. (Optional) For the existing records, you can add Add and Edit Record functionality directly from the Report Builder page, click the three-dot vertical menu adjacent to Save Report, and turn on the Allow New Record Addition toggle.
   Note: If the Enable Add Record toggle is off in General Settings, the Allow New Record Addition toggle appears disabled.

Note: 

• Add and Edit record is interlinked, allowing the admin to enable or disable them together.

• Add and Edit Record supports only low-volume custom objects.

• The Report module admin can decide which reports should have the Add and Edit Record functionality enabled.

• CSM can add and edit new or existing records if the report module admin has enabled the Add and Edit Record functionality on those reports.

3. Clone Report: Clicking Clone Report allows you to clone the selected report.

4. Download Data: allows you to download the report data as an Excel file.

5. Download Image: You can download (except Table) the selected visualization view as an Image.
   Note: Download Data and Download Image options are not available if you disable the Download Report Data options in the General Settings page.
6. Share Report: allows you to share the specific report to selected users. You can also revoke user access to the shared report.

To share a report:

1. Click Share Report.
2. Navigate to Share tab.
3. Type-in and select the user in the Choose Users text box, you wish to share the report with.
   Note: The user must be added as a GS user into the GS User object (in MDA). If you don’t see a user, reach out to your admin to add the recipient as a GS user.
4. Enter the Subject as required.
5. Enter the Note, if required.
6. Select either EXCEL or LINK from the Share as dropdown list.

• EXCEL: Report data is shared as an Excel file with the selected user.
• LINK: Report is shared as a Link with the selected user.
  To share a report through Link, configure the following:

1. Select Domain to send the link. For more information on how to set up a Domain, refer to the Setup a Gainsight Domain article.
2. Select the Enable OTP Verification checkbox, if you want users to access the report link through OTP.
3. Select the Disable Download checkbox, if you want to restrict users to download the data.

7. Select the required Share Type, either Share now or Schedule.

• Share now: allows you to share the report immediately.
  Note: If you select Link as Share as option, you can set the expiry date for the link. 
• Schedule: Schedule the share either Daily or Weekly or Monthly.
  • Daily:  Share the report either Every Weekday (Mon - Fri) or Everyday.
  • Weekly: Select the preferred day in a week to share the report on a weekly basis.
  • Monthly: Select a preferable Date or Day in a month to schedule a share on a monthly basis.

To schedule a report sharing:

1. Select either Daily or Weekly or Monthly. 
2. Select the Start Date and End Date.
3. Set the time in the Select Time text box.
4. Set the required Time Zone from the Select Time Zone dropdown list.

8. Click Share.

Note: Reports created on SFDC objects cannot be scheduled.

To manage the shared report:

1. Click Share Report.
2. Navigate to Manage tab. You can see all the details of the shared report (shared through link).
3. Click Context Menu, to perform the following actions:
   1. Edit: allows you to edit the settings of the shared report.
   2. Delete: allows you to revoke the user access to the shared report.
4. Click Share.