Skip To Content

Parse dates

When visualizing time-series data on a serial chart, you must choose the field that contains the time stamps for your Category Field. These time stamps can be stored in fields of date, string, or numeric type. For best performance, it is recommended that you store your time stamps in a date field type. You can convert string or numeric fields containing time stamps to date fields using the Convert Time Field tool.

If you don't want to convert your string or numeric fields into date fields, you can indicate that these fields contain date values and allow Dashboards to parse the time stamps into dates by enabling Parse Dates. This setting is located on the Data configuration tab under Category Field.

Parse Dates setting

Which date settings appear under the Parse Dates setting when it is enabled depend on the type of field you chose for Category Field.

If the data type of the field is date, no formatting information is required, and you will see only the Minimum Period setting. If you choose a numeric or string field, you will see this setting and the Parsing Pattern setting. The pattern you choose for this setting determines how Dashboards will format your time stamps after parsing them into dates. Also, the time stamps in your data must be stored in the same format you choose for the Parsing Pattern setting. The available patterns depend on whether the field type is numeric or string. You can see whether you chose a date, string, or numeric field for Category Field in that setting's drop-down menu. Each field's type is displayed to the right of the field in the drop-down menu.

Field type for date data

If the field type is numeric (for example, Short, Long, Float, or Double), the following standard numeric time formats are provided in the Parsing Pattern drop-down menu:

  • yyyy
  • yyyyMM
  • yyyyMMdd
  • yyyyMMddHHmmss

If the field type is string, the following standard string time formats are provided in the Parsing Pattern drop-down menu:

  • yyyy
  • yyyyMM
  • yyyy/MM
  • yyyy-MM
  • yyyyMMdd
  • yyyy/MM/dd
  • yyyy-MM-dd
  • yyyyMMddHHmmss
  • yyyy/MM/dd HH:mm:ss
  • yyyy-MM-dd HH:mm:ss
  • yyyyMMddHHmmss.S
  • yyyy/MM/dd HH:mm:ss.S
  • yyyy-MM-dd HH:mm:ss.S
  • yyyy-MM-ddTHH:mm:ss.S
Tip:

For temporal data with sub-second granularity, you can choose to store your time stamps in one of the last four formats listed above. Using one of these formats, you can store time values that represent 1/1,000th of a second (1 millisecond), 1/100th of a second, or 1/10th of a second. For example, if you want to visualize data every millisecond, you can store the time value as 200911231030.560. In this case, the data will draw at the 560th millisecond for the time 200911231030 when visualizing it with the time slider.

The Minimum Period setting determines how time specific the chart categories can be. The options for Minimum Period are as follows:

  • Second
  • Minute
  • Hour
  • Day
  • Month
  • Year

For instance, in the following chart, the minimum period is set to Month. This means that the minimum time period on which a category in this chart can be based is a month, rather than a day, an hour, a minute, or a second.

Chart with minimum period set to month
When the minimum period is set to Month, it also means that a chart category can be based on time periods that are longer than a month, such as a year. Dashboards will base categories on time periods that are longer than the minimum period if there is a high density of data categories based on the minimum period. This avoids displaying labels for each category and creating visual clutter. This means that the Minimum Period setting also impacts which period labels you can specify patterns for on the Category Axis configuration tab. You can't specify patterns for shorter time periods than the one you choose for Minimum Period, but you can specify patterns for longer time periods than the one you choose. For example, if Minimum Period is set to Month, you can't specify a pattern for day labels, but you can specify a pattern for year labels.
Period labels
For more information on how to specify patterns for period labels, see Format dates.