Customize View pane
Introduced in 2023.1
New Experience only
This article describes the Customize View fly-out pane that provides a wide range of options to customize and refine the display of data in data grids. This pane allows you to tailor the data view according to your specific needs, making it easier to analyze and interpret the data. By customizing the data view, you can focus on specific subsets of data, highlight important information, and extract meaningful insights more effectively.
To open the Customize View pane, in the New Experience, click the gear button above the data grid.
The Customize View pane is organized into the following tabs:
Filter - In this tab you can create filters for refining and narrowing down the data displayed in the grid. This is particularly useful when dealing with large datasets or when specific subsets of data need to be analyzed or extracted.
Columns - Use this tab to customize the display of data in the data grid by specifying the fields or columns they want to include.
Options - This tab provides additional customization features.
To close the Customize View pane and return to the main view, click the X button located in the top right corner of the tab. This action closes the pane without applying any changes or filters to the data grid. It provides a convenient way to exit the view customization mode and continue working with the data in the main view.
The Filter tab enables you to specify criteria that the data must meet in order to be included in the grid. This helps in focusing on the relevant information and excluding irrelevant or unwanted data. The filters can be applied to various parameters.
To add a filter, proceed as follows:
Click on the + Add filter button. A list of all fields available in the dataset opens.
Select the filtering parameter you want to apply.
Choose an operator that defines the relationship between the filtering parameter and the filter value. The available set of operators varies based on the context and the data being filtered and depends on the specific filtering parameter selected. For a comprehensive list of operators, refer to this page.
Specify the filter value. To select multiple values simultaneously, hold the Ctrl key.
To refine the filtering further, you can combine multiple filters by clicking on the logical operators AND or OR. This allows you to create complex filtering conditions by adding additional filters.
For advanced users or those with specific filtering requirements, there is an option called Advanced Expression. This feature allows you to enter SQL conditions directly to create more intricate and customized filters. It gives you the flexibility to construct complex queries based on the underlying data structure and the filtering logic required.
In the Filter tab of the Customize View pane, several additional options are available to enhance the filtering experience.
Clone: This action creates an exact copy of the entire set of filters currently defined. The cloned filters are combined with the OR operator, which means that any data matching either the original filters or the cloned filters will be displayed. This feature is particularly useful when you want to create a similar filter with slight modifications without having to start from scratch.
Delete: To remove a specific filter from the set, click the X button next to the parameter name associated with that particular filter. This action removes the selected filter, excluding its criteria from the filtering process. To remove all filters at once, a Delete button is available. Clicking this button clears the entire set of filters, resulting in the display of the complete, unfiltered dataset.
Restoring applied filters
If you have made changes to the filters but want to revert to the original filter configuration, click . This restores the last set of filters that were applied to the data grid.
The Columns tab allows you to specify which fields you want to display as columns in the data grid and how to display them.
To choose which fields to include in the data grid, select them from a list of available options. The list includes all the fields or attributes associated with the dataset you are working with. If the field you want to include is not visible in the initial list, click the + More button and choose the required field from the list.
Changing column order
You also have the ability to change the order of the columns in the data grid. To rearrange the columns, click anywhere inside the field that represents the column you want to move and drag it to the desired position in the column order. This action allows you to customize the visual arrangement of the columns based on your preferences or the specific needs of your analysis.
To remove a field from the display:
Locate the field you want to remove in the list of selected columns.
Click on the three vertical dots icon associated with that particular field. A menu with additional options is displayed.
NOTE: Some fields, such as Flag Status and Ticket, are essential for the functioning of the data grid and cannot be removed. The fields that cannot be removed do not have the three vertical dots menu associated with them.
In addition to selecting fields and customizing the order of columns, the three vertical dots icon associated with each field in the Columns tab offers further options to enhance the display and analysis of data: Summary and Group By.
Using the Summary option
The Summary option allows you to choose a footer value for the column. The footer value provides quick statistical information about the data contained within the column.
For instance, choosing the Count option displays the total number of records present in the column. This is useful for getting a sense of data completeness or identifying data discrepancies.
Selecting the Min option shows the minimum value in the column, allowing you to identify the smallest value present. This helps you determine the lower bounds or minimum threshold within the dataset, which can be valuable for analyzing trends or detecting outliers.
Opting for the Max option displays the maximum value in the column, enabling you to identify the highest value present. This provides insights into the upper bounds or maximum threshold within the dataset, which can be helpful for identifying peaks or exceptional data points.
Using the Group By option
The Group By option, accessible from the three vertical dots icon, is a handy tool for organizing and analyzing data based on specific criteria. Applying this option moves the respective field to the Group By section at the bottom of the tab. Alternatively, you can simply drag and drop a field into the Group By section.
Grouping data helps you gain insights by categorizing and aggregating information based on common attributes or values. This makes it easier to identify patterns, trends, and relationships within your dataset.
This option also allows you to define the order in which the grouping is applied. You can choose whether to group by the actual value of the field itself (the by value option) or by the count of records associated with each distinct value (the by count option).
Additionally, you can specify whether the grouping should be displayed in descending or ascending order, providing further control over the organization and presentation of the grouped data.
The Options tab provides additional customization options for the data view. It currently includes one option, Group by box, which allows you to group data by dragging and dropping columns into a designated box located above the grid. This helps in organizing and analyzing data based on different criteria.
Saving and applying changes
At the bottom of each tab there are three buttons that allow to determine the appropriate course of actions for your customizations:
Save: Saves the current customized view settings for future use. When you have configured the filters, columns, grouping, and other display options according to your preferences, clicking the Save button ensures that your changes are stored and can be accessed later. It preserves the specific configuration of the view, enabling you to quickly load and apply it whenever needed.
Save As: Provides the ability to create a new customized view based on the current settings. This option allows you to save multiple variations of the same view with different configurations. By clicking Save As, you can give the new customized view a distinct name or label, making it easy to identify and recall when required.
Apply: Applies the currently selected customized view settings to the data grid. This enables you to instantly see the results of your customizations without having to navigate away from the Customize View section.