Cummulative not updated since 90 days +

I just installed Eazybi as trial.

In eazybi I have a part of my graphic that get me the not updated issue since more then 90 days over 1 year.

I created in the measure in the column :

NonZero(
Sum(
Filter(
NonEmptyCrossJoin([Issue].[Issue].Members,
[Measures].DefaultMember),
DateDiffDays(
CDate([Issue].CurrentMember.getProperty('Updated at')),
Now()
) > 90
)))

 

I got a quick probably easy question :

How to switch this to get the total cumulative of those issues instead of having them by month ?

Here is a screenshot (blue line):

 

eazybi.png

 

 

 Thanks!

 

1 answer

1 accepted

Hi Martin,

Thank you for trying eazyBI for your reporting needs!

To get the cumulative value it is necessary to sum the number (your original sum) for each month over time. The following formula would do that 

Sum(
  { Generate(StripCalculatedMembers(
        Ascendants([Time].CurrentHierarchyMember)),
      IIF([Time].CurrentHierarchyMember IS
          [Time].CurrentHierarchyMember.FirstSibling, {},
        { [Time].CurrentHierarchyMember.FirstSibling:
          [Time].CurrentHierarchyMember.PrevMember } ) ),
    [Time].CurrentHierarchyMember
  },
  Sum(
  Filter(
    NonEmptyCrossJoin([Issue].[Issue].Members,
      [Measures].DefaultMember
    ), DateDiffDays(
    CDate([Issue].CurrentMember.getProperty('Updated at')),
      Now()
    ) > 90
  )
))

The set in the first Sum is a little complex - it is the same Time set that is used in Open issues formula that works correctly and finds all previous Time members no matter which Time dimension level or hierarchy (default or weekly) you are using.

Note that the original formula is returning the issues that have not been updated for more than 90 days grouped on the time period by their creation date. Maybe it is more efficient to use the "Issues last updated" measure that groups issues on Time based on the date when they were last updated. Then you can filter time to show to more than 90 days ago to see issues grouped by period when they were updated. Please see example report here https://eazybi.com/accounts/1632/cubes/Issues#report/Example%3A%20Cumulative%20Issues%20last%20updated%20for%20unresolved%20issues
 

Let me know if you have any additional questions!
Lauma / support@eazybi.com 

Ah thank you this is exactly what I was looking for.

I just began trying it and we will probably buy this plugin in the near future.

Thanks

Martin Poirier

Ubisoft

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 May 30, 2018 in Marketplace Apps

Three tips for boosting your board's efficiency with Story Maps

Trello is one of the most effective tools for driving your sprints. It's customizable for every Agile team and product owners and Scrum masters (SM) love it. However, Agile teams often struggle with:...

834 views 2 9
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