Transition status updated date


In Eazy BI we have measure (issue property) calles "Issue status updated date" and it looks like 

[Issue].CurrentMember.get('Updated at')

Now, I'd like to get another information: the exact time when Transition status updated 

Id like to get something like that

image2015-2-26 14:51:28.png


Here is the list of my actions:

1) Pick Issues as Row Dimension

2) Drill it across Measures Dimension, using Issue property "Issue status Updated Date"

3) Pick Transition Status as a Column Dimension

Here what i get instead of table needed:

image2015-2-26 15:1:52.png

It all the time shows the date of last status update no matter what transition status i pick

Could you please help me with this case?

Are there any issue property available, something like "Issue transition status Updated date"

We only started learning this complex tool and I haven't got any skill in creating my own properties via MDX query language yet.

1 answer

Hi Aleksey,

You are correct, the 'Issue status updated date' shows the last time the status was updated.

The historic issue status changes are saved in the Transition status dimension and measures. You can group these measures, e.g. Transitions to status and Transitions from status, with Transition status and Time dimension to get total issues that transitioned to/from status during selected time period. Please see example report here

This report has aggregated issues for each time period. By clicking on each column you can select 'Drill through issue' to see which issues did the transition in the selected time period.

Please let me know if you have any additional questions!
Kind regards,

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

1,146 views 5 10
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you