Difference between revisions of "EventStats Quick Start"
From EHS Help
(First draft of import section) |
(No difference)
|
Revision as of 17:21, 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
- Group Name: enter a name that will identify that this column is to be used for your analysis groups or for data filtering. You can specify as many as you want, and 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. Odd numbers are start dates, even numbers are end dates. Multiple pairs of dates can be specified - you choose which to analyse in the next step. Pair dates together by using consecutive numbers. E.g. Admission Date will be date field #1, Discharge Date is then naturally date field #2. Referral date may then be date field #3. You can omit the even number for single dates (like referral date, injury date).
