Configure Aliases in Reports (Horizon Analytics)
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.
Aliases allows Customer Success Managers (CSMs) to make the visual charts in their business review decks more contextual and easily understandable for the target audience such as the Sales Director or a CEO, etc.
Example Business Use Case: For instance, a CSM wants to present a report to the Sales Director on the customer categories defined as per their annual revenue. Admin builds a report on the customer categories defined as per the business stages. For example, here the customers are categorized as: New customer, Launched, Adopting, Will Churn, Churn, etc. But, while sharing the report with the Sales Director, CSMs can use this feature to rename Will Churn as Attention Required, Churn as Lost Opportunity, etc. to make the report more contextual and understandable.
Aliases can be configured on the following data types:
To configure Aliases in Reports:
Navigate to Administration > Report Builder > Reports List.
Aliases can be configured on existing reports or can be assigned while creating a new report. To create new reports, click Create Report.
From the Select Object dropdown, select an object.
Add the required fields to Show Me and Group By.
Select the required chart visualization from the right pane and run the report.
- For configuring Aliases in existing reports, click the Context menu and select Edit Report.
Configure Aliases only after you RUN the report.
Configure Aliases only on the fields added to Group By.
- If you wish to Pivot on the reports, make sure it is applied only after the labels are already configured with Aliases.
Click Settings/Gear icon on the Group By field to which aliases need to be configured.
Click Configure Aliases. The Configure Aliases window appears.
Enter the Alias Name you would like to assign for a value.
Note: Configuring/entering the original and duplicate values in Aliases is not possible.
Click Save, and Run the report to see the Alias Names assigned in the previous step.
- Click Save Report.
Note: Configuring aliases will not have any impact on your original data.
Post Configuration of Aliases
Aliased values persist even after you change the visualization type. You can also see the aliased data in the tabular visualization, but search and sort capabilities are not possible in the aliased column.
Drill Down Reports
Aliased values persist and are shown in drill-down reports upon clicking the visualizations.
Success Snapshot and Dashboard exports: Aliased values persist in both Tabular reports and chart visualizations.
Custom Colors: Custom colors applied on original data are not impacted by Aliases.
Dashboard External Sharing: Aliased values persist on both normal and shared dashboards.
Configuring Aliases is not possible in the reports that are already enabled with Pivot.
Configuring Aliases beyond 30 in a report is not possible. Ranking is disabled for aliased labels (fields).
All Filters, including Global Filters, work on the original value.