Transition status updated date

Hi!

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 https://eazybi.com/accounts/1632/cubes/Issues#report/test%20Transitions%20to%20and%20from%20status%20in%20filtered%20time

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,
Lauma, support@eazybi.com 

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 18, 2018 in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

22,746 views 2 7
Join discussion

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