How to calculate Days in transition status including the time in current status

@martins.vanags yes you are right it did change during 6 month

how can I resolve this issue so that it calculate correctly if something changes during . Date range

@Deepak

Does it mean you want to calculate the historical results based on the current issue type?

If that is the case, you could try using advanced settings to define a new calcualted field, “Current issue type” which would import the current issue type for each issue.

[jira.customfield_curit]
name = "Current issuetype"
data_type = "string"
dimension = true
javascript_code = '''
if(issue.fields.issuetype){
    issue.fields.customfield_curit= issue.fields.issuetype.name
  }
'''

Then select this new field “Current issue type” for import as a dimension from the import options page.
And use this dimension instead of original “issue type” dimension to filter the report.

Martins / eazyBI

Thank you @martins.vanags for yout help

Hello @martins.vanags
Thanks for the formula and the support.

The formula gives the number of days issues are in a given status
How can we get the days issues are in?
e.g.
ISSUE-A is 2 days (20th nov 2022, 21th nov 2022) in status NEW.
How can we list (20th nov 2022, 21th nov 2022)?

Best regards
@Bodi

Hello @martins.vanags ,

I will have another request, the formula gives all days for an issue in a given status.
Let’s say, you have some issues that have been in the following status

Creation of issues, then
a) New → 3 days
b) Open → 2 days
c) Pending → 3 days
d) New → 2 days
e) In review → 3 days

The formula will give issues in status New and with a total of 5 days
How can we get issues that have been in status a) New for 3 days only ?

Best regards
@Bodi

@Bodi
If both transitions happened in different periods, you could filter the report by “Time” dimension.
Time will filter report by “transition from” status.

If a) happened in May 2022 and d) happened in Jun 2022, by filtering the report by May 2022 should give you time in status 3 days.

if that didn’t help, please share more details on your use-case - how will you filter the report (what is layout and which dimensions used in report) and what is the business case for it?

Martins /eazyBI