This article is for Data Center. Visit Cloud
Sample Formulas - Historical Values
- Jaramy Conners
Owned by Jaramy Conners
Show the historical value of an issue field at a specific date
In the example below, we're using the Due Date field. You can use any system or custom field.
historical_value(this, "duedate", datetime("15/May/18 6:24 PM"))Note: this formula also uses the Datetime function
Show the number of tasks added since the last sprint began
SUM {
IF history.changes
.FILTER($.field = "sprint")
.LAST()
.changeGroup.timestamp > sprint.last().startDate: 1
}Show who changed the field value
The example below shows who changed the Resolution field, but you can replace "resolution" with another system or custom field:
history.changes
.FILTER($.field = “resolution”).last().changeGroup.author