(v24) Convert Attributes to Time Fields Using Derived Fields

Convert Attributes to Time Fields Using Derived Fields

This applies to: Visual Data Discovery

If your data contains time-related fields (attributes) that are not stored in a recognized time format, you can convert them to time fields using a derived field. After the derived field is defined, you can use it instead of the original attribute in your Symphony visuals. This is the preferred method because the data in the derived field is constructed as data is read from the data store.

Convert an attribute field to a time field in a derived field

1. Log in as a Symphony administrator or user with the ability to modify a data source configuration.

2. Start creating a derived field as described in Create and Modify Derived Fields.

3. Use the TEXT_TO_TIME function in a row-level expression in the derived field to convert your field to a time field. See Text Functions.

4. Test and save the derived field. See Create and Modify Derived Fields.