The Collateral Data Explorer report provides rich functionality on slicing & dicing performance data. The report allows for filtering, sorting, drill down on the data, column movement, column resize, grouping, drag and drop fields, pivoting and more!

Collateral Data Explorer Functionality:

Users will open the reports section and create a new report, then select the Collateral Data Explorer option: 

Screenshot 2023-08-28 at 15.51.29.png

Then, the Create New Widget screen will open: 

Screenshot 2023-08-28 at 15.53.49.png

Users can change the name of the table, choose the data classes, and select the data as of date from the available periods of the data facility.  

Data As of Date(s) options:

  1. Specific available date
  2. Initial Period Date
  3. Current Period Date
  4. Prior Month
  5. Prior Quarter
  6. Prior Year
  7. Last Day of Last Month - renders the last calendar day of last Month 
  8. Last Day of Last Week - renders the Sunday of the last week 

Upon clicking Generate Table, the report will open with the relevant data:

mceclip2.png

By default, the report shows a counter of each collateral and the collateral name, sorted alphabetically. The user can add additional columns to the report by selecting them on the Column Tool Panel on the right side of the screen:

mceclip3.png

Column Menu Option: 

Users can open the column menu options by clicking on the icon that appears upon hovering over each of columns in the table:

mceclip4.png

This panel provides variety of actions: 

  • Pin column 
  • Auto-size this column 
  • Auto-size all columns 
  • Group by the column 
  • Reset Columns  

Pin Column: 

To use the pin column option users must select the right or left by clicking on the Pin Column and then selecting Left / Right / No Pin. The columns within the table will reorder the columns so that left pinned columns come first and right pinned columns  come last, depending on which selection is made.   

Below is an example of 2 columns that are pinned to the left (Vehicle Model Name & Beginning Balance) and one to  the right (Counter). 

 

mceclip5.png

Auto-Size a Column / All columns:  

Users can auto size the columns in the table by clicking the auto-size option. The system will work out the best width to fit the contents of the cells in the column(s).

Group by Column: 

Users can group by the column that is selected. If the column is already group, then the option that will be shown is to  un-group the column.

mceclip6.png

 

Reset Columns:  Reset the default column setup after generating the widget. 

Expand All: Expand all groups. It is only shown if the table has grouping by at least one column.  

Collapse All: Contract all groups. Only shown if the table has grouping by at least one column.

Column Filtering: You can filter your data at the column level. Many column filters can be active at once (e.g. filters set on different columns) and the grid will display rows that pass every column's filter. 

 

How to use filters: 

• Users can open the Filters Tool Panel by clicking on the icon.

• Columns that are filtered will have the filter icon appear beside the column name 

image-12.png

The filtering option contains a variety of conditions to filter by based on the format of the field: 

Options

  • Character type field filtering options
  • Numeric type field filtering options

Date type field filtering options

  

mceclip7.png
  • The ability to filter on 2  conditions at a time with an  “And” or “Or” operators. The user can also search list of values with autocomplete. 
  • The summary line at the bottom of the table will update dynamically the remaining number of rows based filtered rows: 
  • The ability to filter on 2 conditions at a time with an “And” or “Or” operators. The user can also search list of values with autocomplete.

Column Selection: 

The column selection allows users to decide which columns to display in the table. Users can search for a column name where autocomplete will bring the top the matches results to select. By default the order of the columns is kept in sync with the order they are shown in the table.  

Column Sorting: 

Users can sort their data at the column level on multiple columns. The default action for multiple column sorting is to hold down the Shift key while clicking the column header after sorting the first column. A small number will appear on each column to show the order of the sorting. 

Sorting a Row Group :

By default, the groups are presented randomly and are not sorted in any order. However, the user can sort the grouping column.

Moving a Column:

The columns can be moved in the table by dragging the column headers with the mouse to move the column to the new location

Column Tool Panel: 

The columns tool panel to the right of the table, provides functions for managing the grid's columns:

Pivot Mode Section:

Check the 'Pivot Mode' checkbox to turn the grid into Pivot Mode. Uncheck to take the grid out of pivot mode.  

Columns Section:

Users can decide which columns to display in the table. The user can search for column name where autocomplete will bring to the top the matches results to select. By default the order of the columns is kept in sync with the order they are shown in the table. 

Select / Un-select All:

Toggle to select or un-select all columns in the columns section. 

Drag Handle:

Each column can be dragged to one of the following: 

  • Row Group 

Users can group a column by dragging it to the Row Group section of the Column Tool Panel. For example you can: Drag a column(s) (e.g. Vehicle Manufactured Name & Vehicle Model Name) to Row Groups to group rows or Drag a columns(s) (e.g. Beginning Balance) to Values to aggregate

The group column groups the Vehicle Name and in parenthesis provides a count of rows in each group. The second column displays the sum of the beginning balance by vehicle name.

  • Sorting a Row Group 

By default, the groups are presented randomly and are not sorted in any order. However, the user can sort the grouping column.

Summary Status Bar: 

The status bar appears below the grid and displays information about the data in the grid. Users can see that information by highlighting the relevant rows. 

Pivot Mode 

Users can pivot the data by turning on the Pivot Mode, turning this on is required to be turned on for pivoting to work. When the grid is in pivot mode, the following will happen:

  • Only columns with Group, Pivot or Value active will be included in the table .
  • Only aggregated rows will be shown, the lowest level row Data will not be displayed. If pivot mode is off, then adding or removing pivot columns will have no effect.

Export to Excel:

Users can export the table to Excel by clicking the “Export to Excel” icon located on the top right side of the screen.

Autosave:

The table will autosave every time a change occurs.