Supported data types

You can specify the data type of each column when you import data from a file. The data type you specify dictates how the data is displayed, as well as the filter expressions and actions that are available when viewing and configuring tables, charts, and metrics.

Note

When exporting data from Analytics using the EXPORT command, the data types of the resulting table's columns in the Results app are dictated by the data types of the source table in Analytics.

Selecting data types

During the import process, Results suggests a data type for each column. You can confirm these data types, or if necessary, select a different data type than the process suggests. For example, you can display a number as character data instead of the suggested numeric type.

For more information about importing, see Import data from a file.

Data types

Data type Description Data source Remarks
Logical The simplest data type. Logical data expresses a truth value of either true or false.

 
  • Analytics

Logical data type in Analytics

  • CSV file
  • Excel file

Supported formats:

  • True/False or TRUE/FALSE
  • Yes/No or YES/NO
Numeric Used to represent:
  • integers (0-9)
  • decimal numbers
  • Analytics
  • CSV file
  • Excel file

Example values:

  • 100
  • 100.00
Character Used to represent strings and stored as plain text
 
  • Analytics
  • CSV file
  • Excel file

Example values:

  • John Smith
  • john smith
  • USA
  • California

URLs are also considered a character type that prepends a value with a given protocol (ex. http://).
Date Used to represent the month, day, and year
  • Analytics

Date component of a Datetime field in Analytics

  • CSV file
  • Excel file

Supported format: YYYY-MM-DD
Date and Time Used to represent the month, day, year, hours, minutes, and seconds
  • Analytics

Datetime type in Analytics

  • CSV file
  • Excel file

Supported formats:

  • YYYY-MM-DDTHH:MM:SS
  • YYYY-MM-DD HH:MM:SS

You can specify the UTC offset for local time using one of the following formats:

  • ±[hh]:[mm]
  • ±[hh][mm]
  • ±[hh]

For example, 2017-07-03 23:06:11+05:00 specifies the local time five hours ahead of UTC. This translates to 2017-07-03 18:06:11 UTC.

Note

If you do not specify a UTC offset when you import data, Results assumes the time zone set in Launchpad is the time zone for the data.

The Results app automatically shifts the display of datetime fields to reflect your time zone. For more information, see Working with time zones.
Time

Used to represent hours, minutes, and seconds

 
  • Analytics

Time component of a Datetime field in Analytics

Note

The Results app does not shift the display of time fields to reflect your time zone. Use the date and time type instead to see your time zone reflected in the data. For more information, see Working with time zones.
  • CSV file
  • Excel file

Supported formats:

  • HH:MM:SS
  • HH:MM:SS AM
  • HH:MM:SS PM
File A Diligent One system data type File attachment from a questionnaire response You cannot define fields using the File data type.