How to create Create a Global Filter?

[vatsallya-lamgadey-926c32c9 (Vatsallya Lamgadey)]

Create a Global Filter

Perform the following steps to create a global filter:

1. Navigate to Administration > Dashboard Builder.
2. Open or edit a dashboard.

3. Click the Dashboard Filters icon. The Select Reports window is displayed.
4. In the Name field, enter a name for the filter.
5. From the Select Reports list, select the reports for which you want to apply the global filter.
   6.Notes*:

• By default, no reports are selected.
• You can select all the reports at a time, with a single click, using the checkbox in the search bar.
• You can also search for the report name or object name, and select the checkbox to select all the reports displayed out of the search results.

6. From the Object list, select the required object.
7. From the Field list, select the reference field.
   8.Notes*:

• The reference field is used to infer the datatype of the filter. In case of the Picklist datatype, the Picklist values are used as filter values.
• You can map to any string field when Company Name or User Name is selected as a reference field. For example, you could create a cross datasource Global Filter with Company Name for Gainsight reports and Account Name for SFDC reports.
• If you want to apply global filters on date fields on the reports created from SFDC and MDA objects, it is recommended to use reference field from MDA object.

8. Click NEXT. The Map the fields window is displayed.

Note: An error message is displayed if you try to map a Picklist datatype field from SFDC.

9. Select the field for which you want to apply a filter.
10. Click APPLY. The required filters are added to the dashboard.
    11.Note*: You cannot apply a filter to a field that is already consumed in a different global filter. An error message is displayed when you try to do so.

Notes:

• Only the admin can modify the filter definition or delete the filter.
• The end user can modify only the filter criteria and this change is preserved across the user’s sessions.

11. Once the filters are added, click any of the filters to add a filter value.

12. Click APPLY.
    13.Notes*:

• You can clear the filter value applied by clicking the Clear Filters icon.
• As an admin, you can lock a filter by clicking the icon. If an admin chooses to lock a filter, the end-user cannot modify it in the Gainsight Home page. Each time an admin changes the filter value for a locked filter, it is automatically updated in the Gainsight Home page.

View the Dashboard with the Applied Filters

To view the dashboard with the applied filters:

1. Navigate to the Gainsight Home page.
2. Select the required dashboard. The filter added in the previous section is now applied to the dashboard.

3. As an end-user, you can modify the filter values of unlocked filters in this page and view the updated dashboard.

4. You can add a local filter to a report on the dashboard by clicking the Filter icon corresponding to the report.

Notes:

• The global filters applied to the report are displayed with the prefix G1. Also, the global filters are appended at the end of Advanced Logic with the AND operator by default.
• If a global filter is applied on a field on which a local filter is already applied, the global filter overrides the local filter.

5. You can reset a filter by clicking the Reset Filters icon. Resetting the filter will move it back to the default state, which is the state of the filter defined by the admin when it was created.
   6.Notes*:

• You can reset a global filter to the ANY state only if the admin has set its value to the ANY state when it was created.
• The ANY users filter means the filter is not applied, and the ALL users filter means a filter is applied for all users.