Transition to specific statuses while keeping specific custom field value

[Andrei3000]

Hello community,

I’m trying to create a cumulative report on a timeline which shows issues which transitioned to specific statuses : “Ouvert” , “En description” , “En estimation”, “A faire”.

I also need to make sure the issues which are displayed on the timeline still have “PI n°06” as value from a customfield “Safe - Incrément Programme (PI)”.

The report I have uses dimension “transition status” with individual member activated for each of the statuses I need. I also use the customfield as dimension in “pages” so I can select “PI n°06”.

The timeline view works, nevertheless it also includes issues which are currently in “PI n°07” or “PI n°08”.

I understand these issues were at some point planned for “PI n°06” and moved to “PI n°07” that’s why they show up - but I really need to exclude them from the report.

Thanks for your help

Andrei

[ilze.krauze]

Hi Andrei3000,
It seems that the customfield “Safe - Incrément Programme (PI)” is imported with value change history and therefore shows historical values when used with historical measures.

Most likely it is needed that way for other reports, so to filter by the current value, you need to create a new JavaScript calculated field in your import options, for example, "Current Safe - Incrément Programme (PI)”. Depending on the field type, the JavaScritpt could be like this:

if (issue.fields.customfield_NNNNN) {
    return issue.fields.customfield_NNNNN.value;
  }

When this new field is imported as a dimension (without value changes), you can use it to filter by current PI.

I hope this helps!
Ilze