Difference between revisions of "EventStats Quick Start"
From EHS Help
(First draft of import section) |
m |
||
| Line 1: | Line 1: | ||
== Importing a CSV Data File == | == Importing a CSV Data File == | ||
| − | + | Click the '''Import CSV...''' button which opens the Import CSV File wizard | |
| − | + | Click the '''Open CSV File''' button and select your data file. EventStats will analyse the first 200 rows and present you with the column structure and the sample data it used. | |
| − | + | ||
| − | + | ||
[[File:Eventstats import CSV file before config columns.jpg]] | [[File:Eventstats import CSV file before config columns.jpg]] | ||
| − | + | You must now modify the '''Column Definitions''' to tell EventStats where the data is: | |
| + | |||
| + | * Record Key: this is the field that uniquely defines every record in the data file. | ||
| + | **Enter a '''Y''' is the ''Is Key'' column on the appropriate row. | ||
| + | * Group Name: enter a name that will identify that this column is to be used for your analysis groups or for data filtering. | ||
| + | ** Enter the name directly in the Group column | ||
| + | ** You can specify as many groups as you want | ||
| + | ** The name can be the same as the column name. | ||
| + | ** You must use a different name for each Group column | ||
| + | * Date index: enter a numerical value to identify this field as a date field in the Date index column. | ||
| + | ** Odd numbers are start dates, even numbers are end dates. | ||
| + | ** Pair dates together by using consecutive numbers: 1&2,3&4,5&6 and so on. e.g. If Admission Date is date index: 1, Discharge Date is then naturally date index 2. | ||
| + | ** Multiple pairs of dates can be specified - you can choose which to analyse in the next step. | ||
| + | ** To specify a single date field, just give it the next available odd number & do not allocate the even number to any field. | ||
| + | |||
| + | Example configuration: | ||
| + | |||
| + | [[File:EventStats import CSV file example configuration.png]] | ||
| − | + | == Running Analysis == | |
| − | + | ||
| − | + | ||
Revision as of 17:28, 3 February 2015
Importing a CSV Data File
Click the Import CSV... button which opens the Import CSV File wizard
Click the Open CSV File button and select your data file. EventStats will analyse the first 200 rows and present you with the column structure and the sample data it used.
You must now modify the Column Definitions to tell EventStats where the data is:
- Record Key: this is the field that uniquely defines every record in the data file.
- Enter a Y is the Is Key column on the appropriate row.
- Group Name: enter a name that will identify that this column is to be used for your analysis groups or for data filtering.
- Enter the name directly in the Group column
- You can specify as many groups as you want
- The name can be the same as the column name.
- You must use a different name for each Group column
- Date index: enter a numerical value to identify this field as a date field in the Date index column.
- Odd numbers are start dates, even numbers are end dates.
- Pair dates together by using consecutive numbers: 1&2,3&4,5&6 and so on. e.g. If Admission Date is date index: 1, Discharge Date is then naturally date index 2.
- Multiple pairs of dates can be specified - you can choose which to analyse in the next step.
- To specify a single date field, just give it the next available odd number & do not allocate the even number to any field.
Example configuration:
