Initial "Target End" date

Questions & Answers
1

Hi all,
Is it possible to show the first “Target End” date that was set in a JIRA ticket?
I would like to see what the initial planned date was, and what it was when the feature was completed, sort of a planned vs. actual date.
Thank you!

2

Hi,

You can import the date custom field with the import value change option enabled:

image
image1554×518 33.6 KB

This option creates a new issue property with a comma list of all old values of the date:

ExtractString(
  [Issue].CurrentMember.get('Target end old values'),
  "(.*),.*",
  1
)

The report could look like this:

image
image1502×312 39.2 KB

Kindly,
Janis, eazyBI support

3

Thank you @janis.plume !

4

@janis.plume how do i just return the first value rather than all the values?

5

Hi,

The formula provided should return the first value from the comma list:

ExtractString(
  [Issue].CurrentMember.get('Target end old values'),
  "(.*),.*",
  1
)

Kindly,
Janis, eazyBI support

1 Like
6

Is there any way to get the value as a date so I can show it against the current due date on a chart / look at the time difference between them?

7

Hi,

The following formula is for getting the first value, and you can wrap it into the DateParse to have the result of the Date type:

DateParse(
ExtractString(
  [Issue].CurrentMember.get('Target end old values'),
  "([^,]+)(,.*|$)",
  1
))

Kindly,
Janis, eazyBI support

1 Like