second - script and chart function

Overview

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

The load script contains:

• A dataset containing transactions by timestamp, which is loaded into a table called Transactions.

• The default TimeStamp system variable (M/D/YYYY h:mm:ss[.fff] TT) is used.

• The creation of a field, second, to calculate when purchases took place.

Load script

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

Transactions:
    Load
        *,
        second(date) as second
        ;
Load
*
Inline 
[
id,date,amount
9497,'01/05/2022 7:04:57 PM',47.25
9498,'01/03/2022 2:21:53 PM',51.75
9499,'01/03/2022 5:40:49 AM',73.53
9500,'01/04/2022 6:49:38 PM',15.35
9501,'01/01/2022 10:10:22 PM',31.43
9502,'01/05/2022 7:34:46 PM',13.24
9503,'01/06/2022 10:58:34 PM',74.34
9504,'01/06/2022 11:29:38 AM',50.00
9505,'01/02/2022 8:35:54 AM',36.34
9506,'01/06/2022 8:49:09 AM',74.23
];

Results

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

• date

• second

The values in the second field are created by using the second() function and passing the date as the expression in the preceding load statement.

Overview

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

The load script contains the same dataset and scenario as the first example. However, in this example, the unchanged dataset is loaded into the application. The second values are calculated via a measure in a chart object.

Load script

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

Transactions:
Load
*
Inline 
[
id,date,amount
9497,'01/05/2022 7:04:57 PM',47.25
9498,'01/03/2022 2:21:53 PM',51.75
9499,'01/03/2022 5:40:49 AM',73.53
9500,'01/04/2022 6:49:38 PM',15.35
9501,'01/01/2022 10:10:22 PM',31.43
9502,'01/05/2022 7:34:46 PM',13.24
9503,'01/06/2022 10:58:34 PM',74.34
9504,'01/06/2022 11:29:38 AM',50.00
9505,'01/02/2022 8:35:54 AM',36.34
9506,'01/06/2022 8:49:09 AM',74.23
];

Results

Load the data and open a sheet. Create a new table and add this field as a dimension:date.

Create the following measure:

=second(date)

The values for second are created by using the second() function and passing the date as the expression in a measure for the chart object.

Overview

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

The load script contains:

• A dataset of timestamps, which is generated to represent the traffic to a particular festival's ticket sales website. These timestamps and a corresponding id are loaded into a table called Web_Traffic.

• The TimeStamp system variable M/D/YYYY h:mm:ss[.fff] TT is used.

In this scenario, there were 10000 tickets, which went on sale at 9:00 AM on May 20, 2021. One minute later, the tickets were sold out.

The user would like a chart object that shows, by second, the count of visits to the website.

Load script

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

tmpTimeStampCreator:
load
    makedate(2022,05,20) as date
AutoGenerate 1;

join load
    maketime(9+floor(rand()*2),0,floor(rand()*59)) as time
autogenerate 10000;

Web_Traffic:
load
    recno() as id,
    timestamp(date + time) as timestamp
resident tmpTimeStampCreator;

drop table tmpTimeStampCreator;

Results

Do the following:

1. Load the data and open a sheet. Create a new table.

2. Next, create a calculated dimensions using the following expression:

   =second(timestamp)

3. Create an aggregation measure to calculate the total count of entries:

   =count(id)

The results table will look similar to the table below, but with different values for the aggregation measure: