You are here: Add & manage data > Upload data > Upload data with time attributes

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.

Tip 1: Set the correct data type

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.

Some spreadsheets, including Microsoft Excel, automatically reformat date values from YYYY-MM-DD to MM/DD/YY. Make sure that your source file does not have an altered value. In Microsoft Excel, you can prevent this behavior by selecting the column containing your dates and setting the cell format to Text.

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.

Legal Information