transformations:calendar
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| transformations:calendar [2021/03/14 01:01] – craigt | transformations:calendar [2021/04/02 04:33] (current) – [Examples] dmitry | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{ transformations: | {{ transformations: | ||
| ====== CALENDAR ====== | ====== CALENDAR ====== | ||
| - | Category: Create / Generate | + | Category: Create / Generate\\ |
| + | \\ | ||
| =====Description===== | =====Description===== | ||
| This action creates a table with a list of dates for a specified date range. One row corresponds to one day. Start and end dates can be defined as an absolute or relative date, or defined by a parameter.\\ | This action creates a table with a list of dates for a specified date range. One row corresponds to one day. Start and end dates can be defined as an absolute or relative date, or defined by a parameter.\\ | ||
| + | |||
| + | \\ | ||
| + | =====Use cases===== | ||
| + | Use this action when you need to create a dataset of date-based values (days, weeks, weekdays, months, or years) to be used downstream. | ||
| \\ | \\ | ||
| Line 10: | Line 15: | ||
| ====From==== | ====From==== | ||
| ^ Setting | ^ Setting | ||
| - | |Date|Select an absolute starting date value using the date-picker.| | + | |Date< |
| |Today|Set the starting date as today' | |Today|Set the starting date as today' | ||
| - | |# days back|If the //To// setting is either an absolute date or Today, this sets the starting time as the number of days prior to the //To// date.\\ | + | |# days back< |
| + | < | ||
| + | \\ | ||
| ====To==== | ====To==== | ||
| ^ Setting | ^ Setting | ||
| - | |Date|Select an absolute ending date value using the date-picker.| | + | |Date< |
| |Today|Set the ending date as today' | |Today|Set the ending date as today' | ||
| - | |# days ahead|If the //From// setting is either an absolute date or Today, this sets the ending time as the number of days after the //From// date.\\ | + | |# days ahead< |
| + | < | ||
| + | \\ | ||
| ====Columns==== | ====Columns==== | ||
| These options define the columns that will be included in the generated dataset. | These options define the columns that will be included in the generated dataset. | ||
| Line 32: | Line 39: | ||
| |Day of week (name)|Generates a list of weekday full names (e.g. " | |Day of week (name)|Generates a list of weekday full names (e.g. " | ||
| |Weekend flag|Generates a list of Boolean values (TRUE/ | |Weekend flag|Generates a list of Boolean values (TRUE/ | ||
| - | |||
| - | \\ | ||
| - | =====Use cases===== | ||
| - | Use this action when you need to create a dataset of date-based values (days, weeks, weekdays, months, or years) to be used downstream. | ||
| \\ | \\ | ||
| Line 51: | Line 54: | ||
| |Weekend flag|TRUE| | |Weekend flag|TRUE| | ||
| - | + | \\ | |
| + | =====See also===== | ||
| + | * [[transformations: | ||
transformations/calendar.txt · Last modified: 2021/04/02 04:33 by dmitry