First update of a field not showing

Questions & Answers
1

Hello,
I imported a custom field (resolution date estimate), and as far as I can see the option “import value changes” is flagged in my settings.
When I try to use the following formula:

TimestampToDate(([Measures].[Transition to first timestamp],[transition field].[Resolution Date Estimate]))

I get no value, even for rows with a visible change.
Any help?
Regards

2

please anyone? :expressionless: I’m trying to figure out what’s missing in my configuration but it seems all ok, still for fields that I can see have been altered I get nothing as a first timestamp.

3

Hi,

What I can see from the custom field name, it seems that this field is of date picker type in Jira. You can enable the change import for the date picker fields, but date picker field changes import do not support the Transition mechanism. The changes import creates another property Issue Resolution Date Estimate Old values keeping the comma list of previous date values.

You need a Javascript calculated custom field to find the first date when a date is set for the issue.
The field configuration looks like this:

image
image1354×1030 72.9 KB

The Javascript code is the following (use your field name in the ):

var result=null;
const field_name="Some Date picker"

for (let hist of issue.changelog.histories){
  for (let item of hist.items) {
    if (item.field== field_name) {
      result=hist.created.substr(0,10);
      break
    }
  }
  if (result) break;
}
return result;

After the data import, you will find a new property for the issue:

image
image1700×1024 62.3 KB

image
image1490×1126 80.9 KB

Kindly,
Janis, eazyBI support

4

Thanks a lot!!! I saw that “old values” amongst the other measures, I thought at first that someone else might have added it… now I get it.
Thanks again.

5

another question:

when I set up the “resolution date estimate” field, I “won” the “issue with resolution date estimate” measure.
Now, if I use a time dimension, it seems to filter out the rows that don’t match the current time interval… but it makes no sense. It does not show a blank cell, it filters out the whole row. Do I have to add a nonzero on “issues created” to retrieve them all?

6

Hi,

The Issues with resolution date estimate shows the count of issues by the custom date field if you use this measure with the Time dimension. The behaviour of the measure might be impacted if you use “Hide empty” or “Nonempty” options.

Please contact support with more details about how your report is configured for further assistance.

Kindly,
Janis, eazyBI support

7

hi @janis.plume ,
if I got it right, the javascript picks a substring of the creation date, what if I needed to get the date in which the field has been last updated with a new value?
Hist should get me into the changelog history, “created” is the creation date for the entry with the name equal to my field, but I should get the last occurrence. Something using lastindexof?
regards

8

Hi @Mauro_Bennici

If you remove the break statements, the code should give the last date of when a field is changed:

var result=null;
const field_name="Some Date picker"

for (let hist of issue.changelog.histories){
  for (let item of hist.items) {
    if (item.field== field_name) {
      result=hist.created.substr(0,10);
    }
  }
}
return result;

Kindly,
Janis, eazyBI support

1 Like