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
please anyone? 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.
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:
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:
Kindly,
Janis, eazyBI support
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.
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?
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
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