Organizing columns in Audit reports

  • Last update on August 22nd, 2023

Organizing columns provides you with the ability to customize how your data is presented in the chosen audit report. This feature allows you to sort data, filter specific columns, and decide which columns to display.

Columns can be: 

  • Sorted
  • Filtered
  • Displayed
  • Moved

Here's how each functionality works.

Sort columns

By clicking on the double arrow icon, all items in the report will be organized based on the selected column. This could be in ascending or descending order, depending on your preference.

 

Filter specific columns

This functionality allows you to narrow down the data in a specific column based on certain criteria. Locate the filter icon next to the white rectangle, which appears under the first row of the column you wish to filter and click it to open the filter options. Occasionally, you may find that a column cannot be filtered. This is typically due to the column being hard-coded into the report's definition. There are several ways to filter columns:

 

Select the filter you want to apply from the list provided by clicking on the arrow pointing downwards. Populate the empty fields with your request, and you will be shown the results accordingly. 

Please, note that the options shown in the dropdown menu may vary depending on the type of data in the column

 

 Scenario 1

 You can select the operation and write your request:

 

Scenario 2

You can only select the operation equal/not equal, and select an attribute from the second field:

Scenario 3

 You can select a filter, search for it or select them all. 

Display columns

This functionality allows you to select which columns they want to view in the report by utilizing the eye symbol. By choosing specific columns, you can remove unnecessary information and focus on the most relevant data.

Move columns

The ability to rearrange columns provides you with the flexibility to customize the layout of their data for more efficient analysis. You can move each column to a desired position to suit your specific needs.

To move a column, follow these steps:

  1. Click on the column name that you wish to move. Ensure that you hold down the click.
  2. While holding down the click, drag the column to your desired position.
  3. Release the click to drop the column in its new position.