|
Defining Structure of Statistics Views and Queries |
  
|
|
Defining Structure of Statistics Views and Queries |
|
If you want to see a list of requirement operators, please see the following page:
Query Operators for Requirements
When you choose [Defining Statistical Views (Comprehensive Statistics)] from the [Analysis] menu, you will see the following form. You can change the structure of a view or create new views on this form. However please note that any changes made to a system built-in view will be lost when you restart RaceMate.
The above form is composed of the following parts:
View Title (1) - (2)
On the top of the form, you can find a dropdown list (1) showing the title of the currently editing view. You can change current view by pulling down the list and selecting another view. At the right hand side of the list, there is a textbox (2) showing a description about the view. You may click on the [*] button on its right to zoom the description on a form.
Buttons for Creating, Deleting and Running Views (3)
Below the view title list, you can see a row of buttons for creating, deleting and running views:
[Save+Calc]
Click on this button to open the view on the "Comprehensive Statistics and Record Query" form.
[Insert View]
Click on this button to choose a view from a list and insert it above or below the currently highlighted row in the criteria table. You can save a number of frequently needed columns into particular views and insert them into your new views on-the-fly. In the View Details editing form, you can hide these particular views from the view list of data forms.
[Save]
Save current change and continue editing.
[Save As]
Save the structure currently editing into a new view.
[New View]
Create a blank new view.
[Delete View]
Delete the view currently editing.
View Columns/Criteria Maintenance Buttons (4) - (12)
[Append to End] (4)
Add item from MCL function library into bottom of view structure table
[Insert below Current] (5)
Insert item from MCL function library into view structure criteria table just below the current item
[Overwrite Current] (6)
Copy item from MCL function library into view structure table overwriting the current one
[Insert above Current] (7)
Insert item from MCL function library into view structure table just above the current one
[Insert New View Column (Blank) above Current (8)
Insert blank view item into view structure table just above the current one for editing
[Remove Current] (9)
Remove item currently highlighted from view structure table
[Remove All] (10)
Remove all items from view structure table
[Reset View Structure to Default] (11)
Restore default structure of built-in views. RaceMate will automatically restore all built-in views into their default structure every time you restart RaceMate. However if you want to reset a built-in view without restarting RaceMate, you may click on this button.
[Export & Import View Structure] (12)
Export or import view structure to or from file
Help Button (13)
Push this button to show the help screen
Repositioning View Items (14)
[Move Item Up]
Click on this button to move the currently highlighted criteria up in the criteria table.
[Move Item Down]
Click on this button to move the currently highlighted criteria down in the criteria table.
View Particulars Fine-Tuning Buttons (15)
[View Details]
Click on this button to show the View Details form, on which you can change the view title, define the forms that will show the view, etc. See EditingView Particulars for details.
[Item Details]
Click on this button to show the "Edit View Item" form, on which you can fine tuning the properties of a view item. See Editing View Column/Criteria Items for details.
[Create (.OR.) Brackets]
Click on this button to put the currently highlighted view item into an "OR" criteria group. An OR criteria group is a group of criteria, which are indented in the view structure editing area. If any criteria in this group is valid, the whole OR criteria group is regarded as valid. See Creating and Removing OR or AND Criteria Group for details.
[Create (.AND.) Brackets]
Click on this button to put the currently highlighted view item into an "AND" criteria group. An AND criteria group is a group of criteria, which are indented in the view structure editing area. Only if all criteria in this group are valid, the whole AND criteria group is regarded as valid. See Creating and Removing OR or AND Criteria Group for details.
Column Information Box
A text area at the right bottom of the form shows the details about the column.
MCL Criteria Library Item Editing Buttons (17)
[Edit Item]
Push this button to edit a user-defined library item
[New Item]
Push this button to create a new user-defined item and put it into the MCL Criteria Library
[Delete Item]
Push this button to delete a user-defined library item
MCL Criteria Library Items (18)
The left table shows all the items in the MCL criteria library. You may highlight any of the item and push buttons (4) to (8) to move it into the view structure table.
MCL Criteria Library Item Information (19)
A text area at the left bottom of the form shows the details about the highlighted MCL criteria item.
Please see Statistics and Data Analysis for more information.