EazyBI - How can I get total count of spesific statuses historically

Hi,

 

I would like to get historical status changes like : https://docs.eazybi.com/display/EAZYBIJIRA/History+of+issue+statuses

But the problem is, I would like to get total count of some spesific statuses. For example If I have 5 New, and 3 In Progress issues on 25th of Dec. I would like to see "8" under "Open And Inprogress Issues" title for 25th of Dec.

I think this is possible via custom fields but I could not figure out how to implement.

4 answers

1 accepted

Hi Baris!

 

Peter was right about calculated member in status dimension, only, for historical reports, you should use Transition Status dimensions instead of Status dimension: please read here https://docs.eazybi.com/display/EAZYBIJIRA/Import+issue+change+history.

 

To calculate any metric for Completed statuses, you should create a measure in Measure dimension, for example, "Issues in transition status in previous period"

 

([Measures].[Issues history],
[Time].CurrentHierarchyMember.PrevMember)

 

This measure would calculate a number of issues in selected transition status (for example, Completed statuses) at the end of previous time period.

 

To get a difference between a number of issues in this and previous period, create another metric "Difference" (in Measure dimension):

[Measures].[Issues history] - [Measures].[Issues in transition status in previous period]

 

Now select measures "Issues history",  "Issues in transition status in previous period" and "Difference" from Measures in columns, and "Completed issues" from Transition Status (you can select in Pages as well"). 

 

If you need further assistance with the report, please, contact eazyBI support: support@eazybi.com

 

Ilze, eazyBI Customer Support Consultant

 

1 vote
Peter Bengov Community Champion Dec 29, 2016

Hi Baris,

Under the Statusdimensionyou should select Calculated members and add a new member. 

The name would be [Status].[Open And In progress Issues] and the content will be 

Aggregate ({
[Status].[New],
[Status].[In Progress]
})

Pick that calculated member after you create it and you should be OK. 

Thank you for your answer.

Here is another related problem. I need to get historical status trend of the issues. I have defined two new calculated columns as Open Issues and Completed Issues just like you suggested above. After that, I selected Issues History and these custom fields with Time dimension like below.

Now, I have to show change on Completed Issues count for each month. When I apply that formula: ([Status].[Completed Issues], [Time].CurrentMember.PrevMember) the results are not relevant apparently. I would expect to see previous month's value for the current month. But result looks like the second image below. For example, I expect 374 for Jul 2015 not 287 as below.

Is there any problem with historical calculations?

 

3.jpg29.12.jpg

Hi Baris,

 

In that case, you should define this new calculated member in "Measures" dimension using code that Ilze provided:

([Measures].[Issues history],
[Time].CurrentHierarchyMember.PrevMember)

 

attached example.jpg

 

Please contact support@eazybi.com if you have further questions regarding this!

 

Kind regards,

Martins Vanags / support@eazybi.com

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted yesterday in Confluence

Calling all marketing teams who use Confluence - we want to hear from you!

Hi Community! me again 🙂 If you’re a marketing team using Confluence, we want to hear your story! How did you start using Confluence? What are your use cases? What have been some of the benefits?...

50 views 2 2
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