Repeat - 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 which is loaded into a data table called Example.

• One field in the data table called InputText.

Load script

Example:
Load * inline [
InputText
hello world!
hOw aRe you?
];

Results

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

• InputText

Create the following calculated dimension:

• =Repeat(InputText,2), to calculate the number of times to repeat the value in InputText. In this example, each string will be repeated twice.

The output of the Repeat function includes two instances of the InputText string, for example, row 1 returns hello world!hello world!.

Overview

This example uses customer satisfaction data to convert a numeric satisfaction score into a visual representation using smiley face emojis ☺.

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

The load script contains:

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

• The following fields in the data table:

  • Customer

  • SatisfactionScore

Load script

Example:
Load * inline [
Customer, SatisfactionScore
John,4
Mary,2
Peter,5
Susan,3
];

Results

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

• Customer

• SatisfactionScore

Create the following calculated dimension:

• =Repeat('☺',(SatisfactionScore)), to calculate and display the score visually with emojis.

The output of the Repeat function shows a visual representation of customer satisfaction using smiley face emojis to represent the numerical satisfaction score.

Overview

A dataset of customer accounts contains account numbers with varying character lengths. This example demonstrates how to use the Repeat function to standardize the length of account numbers.

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

The load script contains:

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

• One field in the data table called AccountNo.

Load script

Example:
Load * inline [
AccountNo
123
45125783
41523
489654
];

Results

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

• AccountNo

Create the following calculated dimension:

• =Repeat(0,10 - Len(AccountNo)) & AccountNo, to pad the account number with zeros to a total length of 10 characters.

The output of the Repeat function shows a standardized length of 10 characters for all account numbers.