Yes, you are correct. You can get the 2 transition dates per period correctly. However, you can switch to Day level and see activities per day. Unless you have 2 or fewer status changes to/from the same status you are good to go.
However, we would suggest using calculated JavaScript custom field for more complex scenarios with historical data entries.
We have some community posts on those topics. Here are some of those posts covering different scenarios:
Hi,
I want to calculate the total of Interaction a user has had with an Issue.
Scenario: Any history log that the user has with the Issue: Add a comment, add an attachment, transition an issue, update a field, etc.
Hi Brian,
it seems you may want to benefit from Age in current status interval dimension (instead of Age dimension). This would be a custom dimension.
To get such a dimension, the following steps would be needed:
1.Start with creating a new calculated custom field in eayzBI advanced settings by pasting there the code below:
[jira.customfield_ageinstatus]
name = "Age in current status"
data_type = "integer"
dimension = true
javascript_code = '''
ageinstatus = 0;
issue.changelog.histories.forE…
Hi all,
I’m trying to modify an existing bar chart that currently does the following things:
Displays a count of all issues resolved in a JIRA project over a set period of time
Shows the average resolution time of issues
Shows a histogram breaking down how many issues were solved in set periods of time (i.e. less than a day, 1 day to 7 days, 8 to 14 days, etc)
Unfortunately due to time that issues have spent being Blocked due to external teams the histogram view doesn’t work well to track ho…
Hi,
I trying to see the changes in each date that updated the date custom field “Estimate end date”.
Actually for the defined custom field, only appears the updated last value for all dates. But using the “Hours Spent” Measure show the hours saved for each day.
[result]
I tried to obtain the resoult throug this measure:
[measure]
But for do that is necessary import the custom field like a dimension as a string. If I doing this, is impossible use for calculations or obtain timeline views.
…
Daina / support@eazybi.com