SOS Web - Navigation, Tips, and Tricks

You don’t need an advanced degree in chemistry to take advantage of your oil, coolant or fuel sampling results. Cat S·O·S Services provides knowledgeable interpretations and recommendations you can actually understand—and act on!

USING THE SAMPLES PAGE

The Samples page is the primary interface in the application for:

Viewing lists of samples
Creating advanced searching and filtering of samples
Managing saved searches
Drilling down to see or modify sample details
Displaying a sample graph
Downloading sample data
Displaying sample reports

When you first enter the Samples page, you will see a listing of samples presented in a table view along with column headers and other controls to help you filter, locate, and view information for specific samples.

An Advanced Filters section at the top center of the page can be expanded to select existing filters or to create new ones that you can use to refine the samples displayed.

Clicking on the Lab Number column entry for a specific sample changes the view to Sample Details, where you can examine all information collected on the selected sample.

USING THE SAMPLES TABLE FEATURES

By default, the Samples table will be populated with the last 30 days’ worth of samples. The Lab Date column will show “Last 30 days” by default. This value can easily be changed as can other filtering elements available via many of the column headers. Any changes made to the filters will adjust the sample records display, and will persist as a preference within the current session.

Columns that appear within the table are presented in a default set and order when you first start the interface. Three of these columns-Check Mark, Health, and Lab Number-are displayed at all times. A number of other columns appear by default, but you can select which columns to display and you can adjust column order as you prefer.

Persistent Columns

Check Mark-this column always appears to the left of the first data column in a table row regardless of other table elements; it cannot be moved. After a row is selected using the check mark, the sample can be included in a download or closed using the Close Samples button.
Lab Number-the number assigned to the sample. The column is displayed at all times, but it can be moved to a new position in the table if desired. Clicking on an entry in the Lab Number column changes the view to the Sample Details page for that particular sample number.
Health-the result status of the sample is represented by icons displayed in the Health column. The column is displayed at all times, but it can be moved to a new position in the table if desired. The icons’ alert levels are visible in the drop-down list provided just below the column header.

Clicking on the icons in the Health column opens a summary tooltip similar to that shown below to give you a quick view of the current sample without having to leave the page.

Clicking on the Lab Number entry within the summary tooltip changes the view to Sample Details for the selected sample.

Likewise, clicking on the icons in the Health History column opens a summary tooltip with basic information about the historic sample assigned to the icon.

Optional Columns-Choosing Columns to Display

Click on the Settings (gear) icon found to the right of the column headers to open a drop-down list as shown below. A check mark appearing to the left of a column title signifies that the column will appear within the table; an X mark hides the related column.

Click anywhere outside the drop-down list to close it.

NOTE: The columns that are available for viewing will depend on the user type logged into the system.

The columns that actually appear within the table view depend on the screen real estate available. If more columns are selected than space allows, a plus sign (+) icon appears to the right of the rows signifying that additional information is available.

Health History-One icon appears in this column for each of the preceding three samples for a component. Different sized icons distinguish the most recent historical sample (largest icon) from the second and oldest samples (oldest sample uses smallest icon). Clicking on an icon opens a summary dialog for that specific sample.

Status-identifies the current status of the sample. There are five possible statuses for a sample:

New
In Progress
Closed
In Process-indicates that the sample is currently being analyzed by the lab.
Pending-indicates that the sample has not been received by the lab.

Sorting and Filtering via Column Headers

Column headers are displayed at the top of each column. The headers identify the information displayed in the columns, and they allow you to sort and filter the table data.

To sort data in ascending or descending order, click on the small arrow to the right of a column header then select the desired order. Some columns can also be hidden by clicking on the x Hide Column item in the header’s menu.

Some column headers provide drop-down lists used to select information options; others use direct entry fields in which you can enter specific search elements to more quickly locate a particular sample.

To clear header filters, click on the Settings gear icon located top right of the table then click on Clear all filters.

NOTE: Clicking on Clear all filters from Settings does not clear filters applied via the Advanced Filters feature. An active advanced filter must be cleared by clicking on Reset found in that section.

Arranging Columns

You can rearrange the order of the columns simply by dragging them to the location you want.

Move your mouse cursor over the column title, then click and hold the left mouse button down. As the image below shows, the selected column “detaches” from its original location to confirm which column you are moving.

Drag the column to the desired location then release the mouse button. In a moment, the application will reorganize the table with the column in the new location. When you log out, the system saves the latest configuration so that the table will appear the same in your future sessions.

NOTE: The check mark column is always displayed in the far left column of the table and cannot be moved or removed.

Sizing Columns

You can adjust the width of columns by hovering the mouse cursor between column edges until you see a double-line arrow as shown in the example. Then hold down the left mouse button, drag the column to the desired width then release the mouse button.

Navigating and Managing Samples Lists

Paging controls appear at the bottom of the table (left and right) to facilitate navigation through longer lists of data.

A Showing label identifies the range of results displayed.

A Show filter identifies the number of results shown within the table. As the options suggest, you can show 10, 25, 50, or 100 samples per page.

Controls to the right allow you to select from multiple pages for longer sample sets.

USING ADVANCED FILTERS

Many column headers in the main Samples table provide direct filtering capabilities to help you locate specific samples within your list of samples. In addition, the Advanced Filters feature helps you further narrow down data by giving you the tools to specify multiple conditions (properties) for a given filter, so you can customize the information displayed based on the filter selected.

If you end your session with a filter selected, when you log back in, the system will retain the last filter used and the data presented will be filtered accordingly. In addition, filters set via the column headers will also persist between sessions.

You can use existing filters by clicking on the arrow to the right of the Select filter drop-down list then clicking on the desired filter shown in the list.

Create new filters by clicking on Filter Details then Add Filter Condition.

Specify filter criteria by using lists to choose the property, operator, and in many cases predefined values based on the filter types.

In other cases, you will need to know the value to enter directly, or you may be presented with a Lookup Value dialog box to help you quickly retrieve condition values from information stored in the database.

To further refine search parameters, click again on Add Filter Condition and specify the additional parameters needed.

After creating a new filter, you can click on Apply to have the system refine the samples list presented. Note that applying the filter does not save the filter for future use.

Be sure to click on Save Filter to add the new filter to your list.

Clicking on Reset clears all advanced filter fields, deselects the active advanced filter, and updates the samples display accordingly.

NOTE: Clicking on Reset does not affect filters selected via the column headers. To clear those filters, click on the Settings gear icon located top right of the table then click on Clear all filters.

CLOSING SAMPLES

“New” and “In Progress” samples can be closed under the following conditions. They must have overall interpretations of:

NC (No Comment)
NAR (No Action Required)
MC (Monitor Compartment)
AR (Action Required, but only if an action has been associated with the sample)
AR+ (Urgent Action Required, but only if an action has been associated with the sample)

If the preceding conditions have been met for one or more samples you want to close, check the samples then click on the CLOSE SAMPLES button (above left of the Samples table).

If the system confirms that the criteria for closing the sample(s) have been met, a confirmation dialog box will appear to ensure that you want to complete the action.

If you attempt to close selected samples that do not match the criteria, the system will display a message alerting you that one or more of the selected samples does not match the criteria for closing.

DOWNLOADING DATA

The data set represented in the Samples table can be downloaded as a spreadsheet file in Microsoft XLS format.

The columns in the download will comprise all of the available columns for the Samples table. Results will be downloaded with a column for each result.

You can download results or summary for selected samples by highlighting the check mark for the sample(s) desired then clicking on the DOWNLOAD RESULTS or DOWNLOAD HISTORY buttons.

Downloading results is limited to a maximum of 10,000 records, while downloading sample summary is limited to 15 records. The limits can also be refined by the system administrator.

If your selected download exceeds the specified limit, the system will notify you of the issue so you can narrow your selection or accept a truncated download set.

SAMPLE DETAILS VIEW FEATURES AND FUNCTIONS

The Sample Details view appears when you click on the Lab Number column for a specific sample. This view displays all the data currently stored in the database for the selected sample. As the example illustrates, this view includes a variety of fields and tables showing you information about the customer, user logged in, sample information, asset information, date the sample was received, and more.

The Sample Details view comprises three main areas: the General Information area, the Recommendation area, and the History/Log/Attachments area.

General Information Area

The top area of the page includes six sections:

Sample Activities-the status of a sample is controlled by the Sample Activities drop-down list located in the top left corner of the page
Sample Status-a graphical representation of the current status of the sample. This section is read-only; it cannot be used to change the sample status.
Report Tools-used to generate a Trend Graph or download a LIMS customer report (without contact information).
Sample Summary-includes fields that describe the sample.
Asset Information-includes fields that describe the asset from which the sample was acquired.
Fluid Information-includes fields that describe details about the fluid taken as the sample.

Recommendation Area

The Recommendation Area provides you with further action (if any) recommended for the sample. It includes the recommendation text and an icon indicating the alert level for the sample.

History / Activity Log / Attachments Area

The bottom of the page includes three tabs-History, Activity Log, and Attachments that provided specific information related to the sample.

History Tab

The History tab shows the analyses results for the current sample along with up to four of the immediately preceding samples for the same component.

Depending on the size of the screen, the application will automatically organize the view and will display the history tables so that the information is visible with minimum interaction from the user. For example, in the example below, a larger resolution screen allows the tables to be displayed in full view. On screens with lower resolutions, some tables may be displayed side by side, with collapsible columns.

Clicking on the Show more results link at the bottom of the page (when applicable) will show the entire history for the sampled component.

When no results are available for a particular test, the test column will not be shown. If none of the tests within a table has results, the table will not be displayed.

All history data can be downloaded as a Microsoft XLS file by clicking on the download (MS Excel “X”) icon in the top right of the tab.

Activity Log Tab

Using the Activity Log tab, you can view all of the key events for the selected sample. These events include:

Basic sample life cycle events such as when the sample was created, received, authorized, and so on.
Any activity generated from the Sample Activities drop-down.

The application will display the sample events in chronological order, with the newest displayed at the top of the list.

Several main events (created, updated, emailed, and closed) and secondary events for update (changed status, changed health level, created interpretation, repaired, and so on) can appear in the log. When needed, additional details will be shown. For interpretation, the actual interpretation text will be shown; for a repair, the component, date, and result of the repair will be displayed.

An email event can also trigger one or more secondary actions (created attachment) based on the number of attachments included in an email.

When the contents of an event (commonly interpretation) are too long to display in the space provided, hovering the mouse cursor over the event text will display the complete text in a small dialog box.

You can edit and/or delete sample activities only if you performed them. If transitioned to a different status, edit/delete will not be available for previous events.

Email events cannot be edited or deleted. Any action before the transition of the sample to NEW cannot be edited or deleted.

The results element within an entry can be up to 650 characters long. In cases where the entry is too long to display properly, it will be truncated within the Activity Log tab.

Attachments Tab

The Attachments tab shows the attachments uploaded for the sample being viewed. A number appears next to the Attachments field in the general information area at the top of the Sample Details view so users will be aware that attachments have been added for the selected sample.

Files can be uploaded, downloaded, or deleted from the tab using the controls found at the top of the tab.

NOTE: Attachments can be deleted only if the currently logged in user created the file.

To download or delete a file, ensure that the check mark appears to the left of the target file before selecting the desired function.

When you click on Upload File, a dialog like the one shown below appears so you can locate the file you want to upload. A field appears to the right of the upload file field so you can add a description or other note, which will also appear in the Attachments tab.

USING THE TREND GRAPH

The Trend Graph opens for the selected sample by clicking on the “graph” icon in the top right of the page. The Trend graph provides controls and options to help you view specific details about the sample.

The graph opens with the sample date as the default X-axis and the component pane hidden.

A wide range of the available analysis/result types can be selected from the header bar at the top of the graph.

Range drop-down list

This drop-down list helps you select the date range desired for the related sample. You can choose from:

All samples
Specific date ranges (Last Month, Last Quarter, Last Semester, or Last Year)
Custom date range (enables Start Date and End Date fields
Custom sample range (enables Last Samples field to select last 5 samples, last 10 samples and so on

Test Selection drop-down list

Allows for easy selection of test results to be displayed in the graph.

Show/Hide Data Table icon

Can be toggled on and off to display a data table below the graph.

Chart Types drop-down list

Allows you to switch the graph between chart types including line, area, curve, column, bar, and scatter. The default chart type is “line.”

Settings (gear icon) popup box

Toggle X-Axis between meter and sample date.
Check box to include analysis / test selection by Rate of Wear.
Check box to include analysis / test selection by Normalized Rate of Wear.
Normalization Factor input (this will apply to all Normalized Rates on the Graph at one time).

Download Results button

Clicking on this button downloads the selected data in a .CSV formatted file.

Graph Area Features

Hold left mouse button down and drag to zoom and show more details of any area of the graph.
Mouse-over a data point will show more details of that sample point.
Legend below graph shows test abbreviations (data points).
Clicking on a data point label in the legend toggles the display of the test in the graph.