weekday - 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 a set of transactions for 2022 which is loaded into a table called ‘Transactions’.

• The FirstWeekDay system variable which is set to 6 (Sunday).

• The DayNames variable which is set to use the default day names.

• A preceding load which contains the weekday() function, which is set as the ‘week_day’ field and returns the weekday the transactions took place.

Load script

SET DateFormat='MM/DD/YYYY'; 
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'; 
SET FirstWeekDay=6; 
 
Transactions: 
    Load 
       *, 
       WeekDay(date) as week_day 
       ; 
Load 
* 
Inline  
[ 
id,date,amount 
8188,01/01/2022,37.23 
8189,01/02/2022,17.17 
8190,01/03/2022,88.27 
8191,01/04/2022,57.42 
8192,01/05/2022,53.80 
8193,01/06/2022,82.06 
8194,01/07/2022,40.39 
]; 

Results

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

• id

• date

• week_day

The ‘week_day’ field is created in the preceding load statement by using the weekday() function and passing the date field as the function’s argument.

The weekday() function returns the weekday string value; that is, it returns the name of the weekday which is set by the DayNames system variable.

Transaction 8192 took place on January 5. The FirstWeekDay system variable sets the first day of the week as Sunday. The weekday() function transaction took place on a Wednesday and returns this value, in the abbreviated form of the DayNames system variable, in the week_day field.

The values in the ‘week_day’ field are right aligned in the column because there is a dual number and text result for the field (Wednesday, 3). To convert the field value into its number equivalent, the field can be wrapped inside the num() function. For example, in Transaction 8192, the Wednesday value would be converted into the number 3.

Overview

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

The load script contains:

• A dataset containing a set of transactions for 2022 which is loaded into a table called ‘Transactions’.

• The FirstWeekDay system variable which is set to 6 (Sunday).

• The DayNames variable which is set to use the default day names.

• A preceding load which contains the weekday() function, which is set as the ‘week_day’ field and returns the weekday the transactions took place.

Load script

SET DateFormat='MM/DD/YYYY'; 
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'; 
SET FirstWeekDay=6; 
 
Transactions: 
    Load 
       *, 
       WeekDay(date,1) as week_day 
       ; 
Load 
* 
Inline  
[ 
id,date,amount 
8188,01/01/2022,37.23 
8189,01/02/2022,17.17 
8190,01/03/2022,88.27 
8191,01/04/2022,57.42 
8192,01/05/2022,53.80 
8193,01/06/2022,82.06 
8194,01/07/2022,40.39 
]; 

Results

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

• id

• date

• week_day

Because the first_week_day argument is set to 1 in the weekday() function, the first day of the week is Tuesday. Therefore, all transactions that take place on a Tuesday will have a dual number value of 0.

Transaction 8192 took place on January 5. The weekday() function identifies that this is a Wednesday, and so the expression would return the dual number value of 1.

Overview

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

The load script contains:

• A dataset containing a set of transactions for 2022 which is loaded into a table called ‘Transactions’.

• The FirstWeekDay system variable which is set to 6 (Sunday).

• The DayNames variable which is set to use the default day names.

However, in this example, the dataset is unchanged and loaded into the application. The calculation that identifies the weekday value is created as a measure in a chart in the app.

Load script

SET DateFormat='MM/DD/YYYY'; 
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'; 
SET FirstWeekDay=6; 
 
Transactions: 
Load 
* 
Inline  
[ 
id,date,amount 
8188,01/01/2022,37.23 
8189,01/02/2022,17.17 
8190,01/03/2022,88.27 
8191,01/04/2022,57.42 
8192,01/05/2022,53.80 
8193,01/06/2022,82.06 
8194,01/07/2022,40.39 
]; 

Results

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

• id

• date

To calculate the weekday value, create the following measure:

• =weekday(date)

The ‘=weekday(date)’ field is created in the chart by using the weekday() function and passing the date field as the function’s argument.

The weekday() function returns the weekday string value; that is, it returns the name of the weekday which is set by the DayNames system variable.

Transaction 8192 took place on January 5. The FirstWeekDay system variable sets the first day of the week as Sunday. The weekday() function transaction took place on a Wednesday and returns this value, in the abbreviated form of the DayNames system variable, in the =weekday(date) field.

Overview

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

The load script contains:

• A dataset containing a set of transactions for 2022 which is loaded into a table called ‘Transactions’.

• The FirstWeekDay system variable which is set to 6 (Sunday).

• The DayNames variable which is set to use the default day names.

The end user would like a chart that presents the average sales by weekday for the transactions.

Load script

SET DateFormat='MM/DD/YYYY'; 
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'; 
SET FirstWeekDay=6; 
 
Transactions: 
LOAD 
  RecNo() AS id, 
  MakeDate(2022, 1, Ceil(Rand() * 31)) as date, 
  Rand() * 1000 AS amount 
						
Autogenerate(1000); 

Results

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

• =weekday(date)

• =avg(amount)

Set the measure’s Number Formatting to Money.