All analytical views are based on the same raw data. These data are displayed in a table below the analytical chart.
By default a table has ten rows. To increase this number, select the respective option from the Display [n] rows drop-down above the table. Alternatively, scroll down in the table.
Click Settings above the table to specify which fields shall be shown in the table, how they shall be sorted, filtered, and grouped:
- Under Columns you can add or remove fields that shall be shown. Use the Move to Top , Move Up , Move Down , or Move to Bottom icons to rearrange the order of the columns in the table.
- Under Sort you can define the sorting order. Once you have selected your first sorting criteria from the drop-down, another drop-down will be shown that lets you specify the second sorting criteria. You can rearrange them by selecting the Move Up or Move Down icons.
Note: You can only sort by fields that are shown in visible columns. Otherwise, a No data found error message may be shown. It can be corrected by adding the missing sort field as a visible column to the table.
- Under Filter you can limit the shown data to those that meet certain criteria. Filtering on fields requires the correct format for the filter values, including matching case; for instance, if you filter a case list by the cases' descriptions, the filters Description contains 'test' and Description contains 'Test' will yield different results.
Use the following formatting rules for date-related filters:
- Use the syntax YYYYWW if you use a week-related filter (Closing Week, Creation Week etc.), for instance 202135 for calendar week 35 in 2021.
- Use the syntax YYYYMM if you use a month-related filter (Closing Month, Creation Month etc.), for instance 202106 for June 2021.
- Use the syntax YYYYQ if you use a quarter-related filter (Closing Quarter, Creation Quarter etc.), for instance 20214 for the fourth quarter Q4 in 2021.
- Use the syntax YYYY if you use a year-related filter (Closing Year, Creation Year etc.), for instance 2021.
- Under Group you can display the data grouped by a certain field. For instance, you can show all open cases grouped by Status. In the table each status will be shown and the corresponding cases in that status. Note that grouping and sorting may interfere. When you group data, turn off sorting by that field.
Click Export Table to export the currently shown data to a Microsoft Excel XLS file on your computer. If you have filtered the table, sorted and added additional columns, this is reflected in the exported file.