Hi @Brian_Jones1,
You might want to use a slightly different JavaScript calculated custom field that woudl indicate issues with the changed date field and when those changes were done.
You might want to create a numeric custom field like “XXX date changed” that woudl count changes in the date field, and used together with the Time dimension would show on which date the changes were made. Using this setup, you can filter data with “Time” dimension.
The report might look like in the picture below:
The setup for JavaScript calculated field might look like the below:
And this is the code for custom JavaScript field (you should update it according to your date field name instead of ‘XXX date’):
var datechanges = new Array();
if (issue.changelog && issue.changelog.histories && issue.changelog.histories.length > 0) {
var histories = issue.changelog.histories;
for (var i = 0; i < histories.length; i++) {
var history = histories[i];
if (history.items && history.items.length > 0) {
for (var n = 0; n < history.items.length; n++) {
var item = history.items[n];
//enter here the date field name for XXX date
if (item.field == 'XXX date') {
//change date + counter for change
datechanges.push(history.created.toString().substr(0,10) + "," + 1);
}
}
}
}
};
return datechanges.join("\n");
Please refer to the documentation for more details on how to construct and validate the JavaScript calculated custom fields: Account specific calculated fields.
Best,
Zane // support@eazyBI.com