Organizing columns allows you to change the order, visibility, and sorting of columns in the report. You can sort data, filter specific columns, choose which columns to display, and pin columns to the left side of the table so they always remain visible while you scroll horizontally.
The configuration of a report—including selected columns, their order, sorting, and pinned columns—is saved for future reference. When you reopen the report, it will display as it was last configured. To reset to the default layout, use the “default” option in the column selector.
Please note that any applied filters will not be retained.
Columns can be:
- Sorted
- Filtered
- Displayed (shown or hidden)
- Moved (reordered)
- Pinned (frozen to remain visible while scrolling)
The following sections describe how each functionality works.
Sort columns
By clicking on the double arrow icon, all items in the report are organized within the selected column, in either ascending or descending order. A sorting indicator displays whether the order is ascending or descending.
Filter specific columns
This functionality allows you to display rows in a specific column that match selected 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.
Select the filter you want to apply from the list by clicking on the arrow pointing downwards. Enter the desired filter values in the corresponding fields. The results are updated based on your input.
Note that the options shown in the dropdown menu may vary depending on the data type of the column.
Filter performance notification
When working with reports that contain more than 10,000 rows, applying the “Contains,” “Not contains,” or “Ends with” filter operators will trigger an alert modal. The alert notifies you of possible processing delays and advises narrowing the filter scope or switching to other operators to improve performance.
Display columns
This functionality allows you to select which columns to view in the report from a checklist. Uncheck to hide columns that are not required for the current report view.
Move columns
The ability to rearrange columns allows you to change the order of the columns in the report as required.
To move a column, follow these steps:
- Click on the column name that you wish to move. Continue holding down the mouse button.
- While holding down the click, drag the column to your desired new position.
- Release the mouse button to drop the column in its new position.
Pin columns
The pinning feature allows you to freeze one or more columns on the left side of your report table. Pinned columns remain visible at all times while you scroll horizontally, making it easier to reference important information alongside other data.
To pin a column, simply drag and drop it to the left side of the table—past the vertical line that separates pinned (frozen) columns from unpinned ones. When dropped in this position, the column will automatically be pinned and frozen in place.
You can pin multiple columns by dragging each one you want to keep visible into the pinned area, past the divider line. All columns to the left of the divider will remain visible as you scroll left or right, while columns to the right will move as usual.
To unpin a column, drag it back to the right side of the divider line. It will return to behaving as a standard, scrollable column.
Pinning columns makes it easy to keep key identifiers, such as user names or IDs, in view while analyzing wide reports.