The weeks() function returns the number of weeks between two dates. Syntax weeks(date1, date2) Argument Description date1 (required) An expression that results in a date value (i.e., a hard-coded date, a reference to a date attribute, or a function that returns a date value). date2 (required) An expression that results…
The monthEnd() function returns the date of the end of the Fiscal Calendar month based on a date input. Syntax monthEnd(date) Argument Description date (required) An expression that results in a date value (i.e., a hard-coded date, a reference to a date attribute, or a function that returns a date…
The monthStart() function returns the date of the start of the Fiscal Calendar month based on a date input. Syntax monthStart(date) Argument Description date (required) An expression that results in a date value (i.e., a hard-coded date, a reference to a date attribute, or a function that returns a date…
The quarterStart() function returns the date of the start of the Fiscal Calendar quarter based on a date input. Syntax quarterStart(date) Argument Description date (required) An expression that results in a date value (i.e., a hard-coded date, a reference to a date attribute, or a function that returns a date…
The quarterEnd() function returns the date of the end of the Fiscal Calendar quarter based on a date input. Syntax quarterEnd(date) Argument Description date (required) An expression that results in a date value (i.e., a hard-coded date, a reference to a date attribute, or a function that returns a date…
The yearStart() function returns the date of the start of the Fiscal Calendar year based on a date input. Syntax quarterStart(date) Argument Description date (required) An expression that results in a date value (i.e., a hard-coded date, a reference to a date attribute, or a function that returns a date…
The yearEnd() function returns the date of the end of the Fiscal Calendar year based on a date input. Syntax yearEnd(date) Argument Description date (required) An expression that results in a date value (i.e., a hard-coded date, a reference to a date attribute, or a function that returns a date…
08 March 2025 (Note: Official Release Notes are available as an attachment to this article.) Enhancements: Save as Dashboard Table Custom Conditional Formatting: Timeframe Columns X/Y Charts: Drilldown Functions to return start and end dates of fiscal calendar month, quarter, and year Function to return the count of weeks between…
22 February 2025 (Note: Official Release Notes are available as an attachment to this article.) Enhancements: Updating AWS Infrastructure Issue Resolutions: Custom Chart drill down does not update when Page Filters change 226.0 Release Notes
Overview The Table section is an extremely performant display of work items (i.e., instances of a template) or associations. Tables can be configured to include editing of data or creation of new work items. Table’s structure can vary based on their column and row definition, the table displayed in the…