Sequence

Last updated: 06 Jan 2023

Description

The Sequence node is used to complete a sequence of rows. It can add rows to fill gaps in numeric data and also do the same for date based data.

Configuration Options

Basic Configuration Options

Setting	Description\Parameters
Split Columns	The selected column(s) will be used to split the data set over when calculating summary metrics.
Sequence Column	Actuals data column.
Mode	Determines whether the sequence is numeric in nature or based on date format. Options

• Numeric
• Date

| |Date Granularity|When Date is selected for the Mode setting above, this field specifies the date format used.

Options

• Day (`YYYYMMDD` format)
• Week(`YYYYMMW` format)
• Month (`YYYYMM` format)
• Quarter (`YYYY'Q'Q` format e.g. `2010Q1`)
• Year (`YYYY` format)

| |Sequence Start|Indicates the strategy used for the first value in the sequence.

Options

• Occurrence - Uses the first value found in the Sequence Column for the defined Split Columns.
• Global Minimum - Uses the minimum value found in the Sequence Column across all the input data.
• Global Maximum - Uses the maximum value found in the Sequence Column across all the input data.
• Custom - Uses the custom define value provided in the Custom Value setting.

| |Sequence End|Indicates the strategy used for the last value in the sequence.

Options

• Occurrence - Uses the last value found in the Sequence Column for the defined Split Columns.
• Global Minimum - Uses the minimum value found in the Sequence Column across all the input data.
• Global Maximum - Uses the maximum value found in the Sequence Column across all the input data.
• Custom - Uses the custom define value provided in the Custom Value setting.

|

Column Fill Options

Setting	Description\Parameters
Column Name	Name of the column you would like to populate with a value.
Value Type	Indicates the strategy used for the last value in the sequence. Options Occurrence - Uses the prior row's value found in the Column Name column. Custom - Uses the custom define value provided in the Custom Value setting. Increment - Uses the the last value of the Column Name column and increments it by the Custom Value amount. Decrement - Uses the the last value of the Column Name column and decrements it by the Custom Value amount.
Custom Value	When valid, this is the specific fill value used.

Actions

Action	Description
Preview	After configuring the node, the combined result set can be previewed by clicking the Preview button.