Timestamp# - script and chart function

Overview

Open the Data load editor and add the load script below to a new section.

The load script contains:

• A dataset which is loaded into a data table called Example.

• The following field in a data table:

  • InputString

• A preceding load that uses the Timestamp# function to treat the expression as a date and time value. When executed, it creates an additional field called TimeStamp_InputString.

Load script

SET DateFormat='M/D/YYYY'
Example:
Load *,
Timestamp(Timestamp#(InputString)) as TimeStamp_InputString;
LOAD * INLINE [
InputString
2015-09-15T12:13:14
1952-10-16T13:14:00+0200
1109-03-01T14:15
];

Results

Load the data and open a sheet. Create a new table and add these fields as dimensions:

• InputString

• TimeStamp_InputString

In this example, you can see how string values can be evaluated as a timestamp using the Timestamp# function.

Overview

Data from an event log contains a timestamp format that you want to use.

Open the Data load editor and add the load script below to a new section.

The load script contains:

• A dataset which is loaded into a data table called Example.

• The following fields in the data table:

  • Event
  • EventDateTime

• A preceding load that uses the Timestamp# function to convert the values in the EventDateTime field into a date and time format that the system can understand. When executed, it creates an additional field called EventTimestamp.

Load script

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
Example:
LOAD
Event,
EventDateTime,
Timestamp#(EventDateTime, 'DD-MM-YYYY hh:mm:ss') AS EventTimestamp
INLINE [
Event, EventDateTime
"Login", "12-03-2023 10:25:30"
"Logout", "12-03-2023 12:45:10"
"Login", "13-03-2023 09:10:15"
"Logout", "13-03-2023 17:30:20"
"Login", "14-03-2023 08:00:00"
];

Results

Load the data and open a sheet. Create a new table and add these fields as dimensions:

• Event

• EventDateTime

• EventTimestamp

Create the following measure:

• =Timestamp(EventTimestamp), to view the timestamp formatted using the format supplied in the load script as a default setting.

In this example, you can see how values can be converted using the Timestamp# function.