The Trend Analysis page plots a graph of the test results and the specified tolerances versus the execution
dates. Therefore, it displays the pattern or trends of the executed tests within the selected time period.
To open the Trend Analysis page, click the Trend Analysis button on the title bar (2b).
Selecting a Test
To display the plot(s) of a test result,
- Select its machine and the task in the task navigation (1) (see detailed information about this panel in Section 4.2). Only one task of a device can be selected at the same time.
- A test included in this task can then be selected in the upper part of the main area (2a) for the trend
analysis.A task may contain many tests. They may be displayed in several pages. It might be necessary to move SSforward and back through the pages (2a-i) to find the desired test.
- To facilitate a test selection, the test name can be filtered by a full-text search based on the name (2c). For example, enter “output” in the filter, the test names containing “output” (not case-sensitive) are displayed.
- For the selected test, the results used for analysis can be shown for different ranges of dates (2a-ii):
- Last 7 Days - loads the data of the last 4 weeks (A) but displays the last 7 days as initial selection (B). See an example below.
- Last 4 Weeks - loads 6 months of data, displays last 4 weeks initially
- Last 6 Months - loads 1 year of data, displays last 6 months initially
- Last 12 Months - loads all data, displays last year initially
- All - loads all data, shows all data initially
Change the selected dates
The selected area can be changed by placing the cursor inside the navigator (C), pressing the left mouse,
and dragging the navigator to a desired position. In the navigator area, once the left mouse is pressed, the range of the selected dates are shown (D). The information is updated upon the change of the dates.
Change the range of the selected dates
Place the cursor on one of the boundaries (E) of the navigator (the cursor will become double arrows), press down the left mouse button, and drag it to the desired date.
Trend Analysis Graphical Display
Tests with numerical results
After a test is selected (see the previous section), the trend analysis of this test is plotted as a line chart in
the lower part of the main display area of the Trend Analysis tab page (2d).
- The vertical axis represents the test values and the horizontal axis represents the dates when the test was performed.
- The blue dashed line : connect the expected values.
- The green solid line : connects the actual measured data points.
- The red dashed line : top/bottom - connect the upper/lower failed limit.
- The orange dashed line : top/bottom - connect the upper/lower warning limit.
Tests with Pass/Warning/Fail results
For the Pass/Warning/Fail tests, trends are displayed for all executed tests with the following result
indicators:
: Pass;
: Warning;
S: Fail
Tooltip for a data point
The coordinates of a data point (test result and test date, 1) can be viewed by hovering the mouse cursor
over the data point that represents this test. If a test note is entered during the test run in the myQA
Machines workspace, the note will also be displayed (2). If the test was executed with myQA version 2.10 or earlier, the tooltip will inform that it was generated with an old version of the plugin (3).
Export Trend Analysis as a *.csv File
Export as a *.csv File
When a test with trending data is selected, the Export as CSV button appears on the upper
right-side of the graphical display. With this button, the displayed Trend Analysis can be exported as a CSV format file.
- Click the Export as CSV button.
- Click the Save expanding icon and choose Save as. Select the desired location and then save
the file. By default, the filename is [test name]_YYYY-MM-DD.csv, e.g., 1.01 Electron output
constancy_2018-06-20.csv.
Open a *.csv File with Excel
The saved *.csv file is stored as plain text file and it is automatically linked to Excel when Microsoft Excel
is installed on the computer. It can be opened with Excel by double-click the filename. However, only a
German formatted PC will display the columns correctly, for an English formatted PCs, for example, it is
possible that all text is displayed in one column. See an example:
In this case, please follow the procedure below to separate the columns.
Note: When importing the exported CSV file, please use the Convert Text to Columns Wizard to set ";" as the delimiter if this is not your default Windows delimiter.
- Select all cells of the column with text. Click the tab and then Text to Columns in the Data ribbon. The Convert Text to Columns Wizard opens. Select Delimited in the Original data type box in Step 1.
- Select Semicolon in the Delimiters box in Step 2.
- In Step 3, select the first column, and then in the Date box choose YMD.
- Click Finish.
About the date format
The date stored in the ANSI format is: YYYY-MM-DD. When the csv file is opened with Excel, it recognizes
this field as a date and transforms it into the local format, e.g., dd.mm.yyyy in this case it is the German
date format.
Procedure for displaying a different date format:
- Select and right-click a column; select Format Cell in the context menu.
- In the Format Cells dialog, select Date, a country under Local (location), and a format under Type.
- Click OK.
About decimal separator and thousands separator
If the decimal separator and thousands separator need to be changed:
- Select the affected columns.
- Click the Advance button.
- Select the desired characters in the Decimal separator and Thousands separator boxes.
- Click OK.