minute - 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, minute, to calculate when transactions took place.

Load script

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

Transactions:
    Load
        *,
        minute(timestamp) as minute
        ;
Load
*
Inline 
[
id,timestamp,amount
9497,'2022-01-05 19:04:57',47.25,
9498,'2022-01-03 14:21:53',51.75,
9499,'2022-01-03 05:40:49',73.53,
9500,'2022-01-04 18:49:38',15.35,
9501,'2022-01-01 22:10:22',31.43,
9502,'2022-01-05 19:34:46',13.24,
9503,'2022-01-04 22:58:34',74.34,
9504,'2022-01-06 11:29:38',50.00,
9505,'2022-01-02 08:35:54',36.34,
9506,'2022-01-06 08:49:09',74.23
];

Results

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

• timestamp

• minute

The values in the minute field are created by using the minute() function and passing the timestamp 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.

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

However, in this example, the unchanged dataset is loaded into the application. The minute 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,timestamp,amount
9497,'2022-01-05 19:04:57',47.25,
9498,'2022-01-03 14:21:53',51.75,
9499,'2022-01-03 05:40:49',73.53,
9500,'2022-01-04 18:49:38',15.35,
9501,'2022-01-01 22:10:22',31.43,
9502,'2022-01-05 19:34:46',13.24,
9503,'2022-01-04 22:58:34',74.34,
9504,'2022-01-06 11:29:38',50.00,
9505,'2022-01-02 08:35:54',36.34,
9506,'2022-01-06 08:49:09',74.23
];

Results

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

Create the following measure:

=minute(timestamp)

The values for minute are created by using the minute() function and passing the timestamp 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 entries at a ticket barrier.

• Information with each timestamp and its corresponding id, which is loaded into a table called Ticket_Barrier_Tracker.

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

The user would like a chart object that shows, by minute, the count of barrier entries.

Load script

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

tmpTimeStampCreator:
	load 
		*
    where year(date)=2022;
load
	date(recno()+makedate(2021,12,31)) as date
AutoGenerate 1;

join load
	maketime(floor(rand()*24),floor(rand()*59),floor(rand()*59)) as time
autogenerate 10000;

Ticket_Barrier_Tracker:
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. Create a calculated dimension using the following expression:

   =minute(timestamp)

3. Add the following aggregation measure to calculate total count of entries:

   =count(id)

4. Set the measure's Number formatting to Money.