GMT - script and chart function

Overview

Open the Data load editor and add the load script below to a new tab. This example will set the current Greenwich Mean Time as a variable in the load script using the GMT function.

Load script

LET vGMT = GMT();

Results

Load the data and create a sheet. Create a text box using the Text & image chart object.

Add this measure to the text box:

=vGMT

The text box should contain a line of text with a date and time, similar to the one shown below:

3/28/2022 2:47:36 PM

Overview

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

The load script contains:

• A dataset containing overdue library books, which is loaded into a table named Overdue. The default DateFormat system variable MM/DD/YYYY is used.

• The creation of a new field called days_overdue, which calculates how many day overdue each book is.

Load script

SET DateFormat='MM/DD/YYYY'; 

Overdue: 
    Load 
        *,
        Floor(GMT()-due_date) as days_overdue
        ;
Load 
*
Inline
[
cust_id,book_id,due_date
1,4,01/01/2021,
2,24,01/10/2021,
6,173,01/31/2021,
31,281,02/01/2021,
86,265,02/10/2021,
52,465,06/30/2021,
26,537,07/26/2021,
92,275,10/31/2021,
27,455,11/01/2021,
27,46,12/31/2021
];

Results

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

• due_date

• book_id

• days_overdue

The values in the days_overdue field are calculated by finding the difference between the current Greenwich Mean Time, using the GMT() function, and the original due date. In order to calculate only the days, the results are rounded off to the nearest whole number using the Floor() function.

Overview

Open the Data load editor, and add the load script below to a new tab. The load script contains the same dataset as the previous example. The default DateFormat system variable MM/DD/YYYY is used.

However, in this example, the unchanged dataset is loaded into the application. The value of the number of days overdue is calculated via a measure in a chart object.

Load script

SET DateFormat='MM/DD/YYYY';
					
Overdue:
Load
*
Inline
[
cust_id,book_id,due_date
1,4,01/01/2021,
2,24,01/10/2021,
6,173,01/31/2021,
31,281,02/01/2021,
86,265,02/10/2021,
52,465,06/30/2021,
26,537,07/26/2021,
92,275,10/31/2021,
27,455,11/01/2021,
27,46,12/31/2021
];

Results

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

• due_date

• book_id

Create the following measure:

=Floor(GMT() – due_date)

The values in the days_overdue field are calculated by finding the difference between the current Greenwich Mean Time, using the GMT() function, and the original due date. In order to calculate only the days, the results are rounded off to the nearest whole number using the Floor() function.