Customizing a Summary View
When designing a Summary View, the Zoho Advanced Analytics app offers a wide range of options to customize the view to suit your needs. In this section, we will discuss the various options provided by Zoho Advanced Analytics to customize a Summary View that you create.
Zoho Advanced Analytics app allows you to customize the appearance of the Summary View (like adding description, hiding row numbers etc.).
To customize the appearance of the Summary View, follow the steps given below:
- Open the Summary View you would like to customize.
- Select Settings option in the toolbar. This will open the Settings page. You will notice that this page contains three tabs - General, Format, and Display.
Title and Description
Zoho Advanced Analytics app provides options to modify the title and description in the General tab of your Summary View.
- Title: You can edit the title of your Summary View from here. This field is mandatory.
- Description: You can change the description of your Summary View from here. This field is optional.
Zoho Advanced Analytics allows you to change the display labels and display format of the data columns used in your Summary View as required.
You can edit the following details from the Format tab:
- Label: You can edit the labels of the columns in your Summary View.
- Format: You can change the format of the data displayed in your Summary View. The options in the Format dialog will vary depending on the data type of the column. These options will be similar to that of the table column formatting options in Tables. For more details refer here.
Zoho Advanced Analytics allows you to customize the layout of your Summary View.
Under the Display section, you can customize the following options:
- Hide row numbers: Select this checkbox if you do not wish to display the index number for the rows. By default, this will not be selected.
- Wrap text in Column Headings: This wraps the text in a column header to next line in case the column headers are lengthy.
- Repeat group label value in each row: Select this option in case you wish to repeat the group label for each row.
- Set default column width to: You can uniformly resize the columns by selecting this checkbox and then specify the required width in pixel in the provided field. You could also choose to apply this new width to the already resized columns using the Apply to manually resized columns checkbox.
- Display 'Unknown' value as: Null or empty value present in the underlying data of the Summary View will be displayed as -No Value- by default. You can specify an alternate value that could be displayed instead of this in the Display 'Unknown' value as field.
You can easily rename columns in the Zoho Advanced Analytics app by following the below steps:
- Open the Summary View in Edit Mode.
- Right-click the column header and then select Rename Column. Alternatively, you can also rename the column by clicking the Edit icon that appears on mouse over the column name.
To sort a column:
- Right-click the column header.
- Select one of the following sorting options:
- Sort Ascending - Sorts text data in ascending alphabetical order (A to Z), numbers from smallest to largest (0-9), and dates from oldest to latest.
- Sort Descending - Sorts text data in descending alphabetical order (Z to A), numbers from largest to smallest (9-0), and dates from latest to oldest.
- Remove Sorting - Clears the applied sorting.
Conditional formatting feature allows you to visually highlight data cells in a Summary View with different styles based on matching conditions. You have to specify the required conditions/criteria for formatting. The condition that matches first with the data cell will be applied.
To apply conditional formatting:
- Open the Summary View for which you want to apply Conditional Formatting.
- Right-click on any one of the cells in the data series for which you want to apply conditional formatting.
- In the menu, click Conditional Formatting.
- The Conditional Formatting dialog opens with options for specifying the conditions and selecting colors for font and background.
- Click the drop down arrow under the Condition header and select the type of condition that you want to apply.
- Type the matching value that you want to use for the condition in the Value text box.
- Select the required colors for the font and background.
- You can also insert texts and icons using the Additional Formatting Options dialog to highlight your condition. Click the icon to add text and icons.
- You can add any number of conditions using +Add Condition link.
- Conditions specified will be evaluated from top to bottom and the corresponding formatting options that matches first will be applied on the data cell that meets the condition. Click OK after you have added all the conditions.
The summary view after adding the required conditions will be as displayed in the screenshot below.
You can view and modify all the conditional formats applied over the Summary View from the Conditional Format tab of the Settings section.