Upload data with time attributes
The Research report can filter and aggregate data by temporal attributes like day, week, and month. The units of time available depend on how the data is represented in the dataset. For example, if the dataset represents values by week, you cannot filter by day because the dataset does not support that level of detail. You also cannot specify dates or times not included in your dataset (for example, if your earliest date is March 20, you cannot set a search filter starting with March 1).
To get the most out of your temporal data attributes, use these three tips.
Rhiza for Research has two options for time and date data. Make sure you choose the correct type:
- Date: Use this for any temporal values of a day or larger; its value is a whole number. Time values included with this type are ignored.
- Date Time: Use this for any temporal value that includes a value smaller than a day, including data that has both a day and a time in the same field.
If your data contains mixed types (for example, some values include times, while others don't), choosing Date Time will preserve the time values that do exist and add a default time of midnight for the rest.
Tip 2: Format your data correctly
Make sure that your dates are formatted as YYYY-MM-DD in the upload file.
Tip 3: Understand how Rhiza for Research interprets the formatting
|Input value||Date as interpreted by Rhiza for Research||Notes|
|2014-05-04 13:24||May 4, 2014 at 1:24 PM|
|2014-05-04 13:24:55||May 4, 2014 at 1:24:55 PM||The Research report doesn't currently support filtering by less than one minute|
|2015-08-31 8:00 PM||August 31, 2015 at 8:00 PM|
|2015-08-31 8:00||August 31, 2015 at 8:00 AM||If no AM or PM value is included, the value is interpreted as 24-hour time.|
|2009-12||December 1, 2009||Omitted values are assumed to be 0, or in the case of a month, the first day.|
|2017||January 1, 2017||In this case, the omitted value for the month is assumed to be the first month, and the omitted value for the month is assumed to be the first day.|
© 2016, Rhiza, Inc. All rights reserved. Last updated September 11, 2015 01:13:18 PM.