How to work through Column heading menu

How to work through Column heading menu



Column Heading Menu 

Clicking on any column heading exposes a column heading menu.

 

Options include:
Sort Ascending           icon sorts the report by the column in ascending order.
Sort Descending        icon sorts the report by the column in descending order.
Hide Column              hides the column. Not all columns can be hidden. If a column cannot be hidden, there will be no Hide Column icon.
Break Column            creates a break group on the column. This pulls the column out of the report as a master record.

Column Information displays help text about the column, if available.
Text Area is used to enter case insensitive search criteria (no need for wild cards). Entering a value reduces the list of values at the bottom of the  menu. You can then select a value from the bottom and the selected value will be created as a filter using '=' (for example, column = 'ABC'). Alternatively, you can click the Flashlight icon and enter a value to be created as a filter with the 'LIKE' modifier (for example, column LIKE  '%ABC%').
List of Unique Values contains the first 500 unique values that meets your filter criteria. If  the column is a date, a list of date ranges is displayed instead. If you select a value, a filter will be created using '=' (for example, column = 'ABC').



    • Related Articles

    • How to use the Action Menu

        HOW TO USE THE ACTION MENU The Actions Menu appears to the right of the Go button on the Search bar. Use this menu to customise an interactive report. action menu Select Columns Used to modify the columns displayed.  Columns You can reorder the ...

    • Report Instrument Groups Activities

      How to work with the Report "Instrument Groups Activities" This report allows you to retrieve data, create charts and tables based on activities performed with specific instrument groups or instrument report groups. The column view can be ...

    • Report Task Classification Report

      How to work with the Report "Task Classification" This section allows the user to view a list of all the tasks, classified by different criteria. The column view can be personalized according to the needs of the user. Data can be sorted, filtered, ...

    • Report Instruments Occupancy

      How to work with the Reports of Instruments Daily & Weekly Occupancy This report allows the user to displays the daily or weekly occupancy of the instruments. Input to be given to the system The user will have to indicate the starting date and the ...

    • Report Use of Scheduling Features

      How to work with the Report page of "Use of Scheduling Features" Access to the Use of scheduling features report is from the Icon below on main report page. In this section, it is possible to select a specific timeframe (ranging from 15 minutes to 4 ...