EazyBI: Is it possible to aggregate the time estimate released on a monthly basis?

Hi,

The requirement is to represent the sum of estimate released every month (also in the future).

There should be the Time dimension in the Rows which represents the fix versions which release date is in the month (we have like many small releases every monty). The fix versions name is usually starting with "2016-EL".

Our first try was to filter the fix versions with the 2016-EL names and generate the month Time entries based on the release date but it is kind of tricky.

The Columns should contain the sum of time estimate and optionaly the sum of issues released in the 2016-EL fix versions per month.

Our first try was to put the 2016-EL fixVersions on the Rows and it does the job but the x asis is not sorted per release date and we do not see the trend of how much estimate is released every month and will be released in the future.

Has someone created such a report before? Are there some hints or examples somewhere?

We appriciate every help on this. Thanks.

2 answers

1 accepted

I finally managed to get the issues aggregated with the following MDX custom measure: 

Sum(
  Filter(
    [Fix Version].[Version].Members,
    DateInPeriod(
      [Fix Version].CurrentMember.get('Release date'),
        [Time].CurrentHierarchyMember
    )
    AND ([Time].CurrentHierarchy.DefaultMember,
      [Measures].[Issues created history]) > 0
    AND [Fix Version].CurrentMember.Name MATCHES '^201\d-EL-\d.*'
  ),
  [Measures].[Issues created history]
)

When using it combined with the Time dimension on Rows it gives us the aggregated values by month containing the release date.

Hi Michal,


In this case, you could try adding "Fix Version" dimension in rows and measures "Original estimated hours" and "issues resolved" in columns of your report.

 
Additionally, you should select measure "Version release date" which you use just to sort the report (by clicking on this column and selecting to order it) and then you remove this measure, but doing so the report will stay filtered.


sort fix versions by release date.gif

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

 

Kind regards,

Martins Vanags / support@eazybi.com

Hi,

Thanks for the answer. It was not exactly what we wanted, but the trick with sorting is greate to remember! Vote up for this!

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
Published 15 hours ago in Off-topic

Get to know our Atlassian User Group Leaders from Bengaluru, India

Meet @Dinesh Dhinakaran, @Vishnu Vasudeva, @Rajeev Verma, and Jamshid Nalakath: Our extraordinary AUG leaders from Bengaluru, India. These four work together to strengthen the bonds of their local co...

109 views 0 4
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