Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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 :

CDate([Issue].CurrentMember.getProperty('Updated at')),
) > 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):







2 answers

1 accepted

1 vote
Answer 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 

  { Generate(StripCalculatedMembers(
      IIF([Time].CurrentHierarchyMember IS
          [Time].CurrentHierarchyMember.FirstSibling, {},
        { [Time].CurrentHierarchyMember.FirstSibling:
          [Time].CurrentHierarchyMember.PrevMember } ) ),
    ), DateDiffDays(
    CDate([Issue].CurrentMember.getProperty('Updated at')),
    ) > 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

Let me know if you have any additional questions!
Lauma / 

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.


Martin Poirier


What is Ascendants and descendants here in terminology?

Please suggest.

Hi @M !

The Ascendants function returns the 'parents' of a member, while the Descendants return the 'children' starting from the member. See more here

As described, this part finds all previous Time members starting from the time member that is currently on rows. For some time now more user friendly would be to use the PreviousPeriods() function.

Please also consider creating custom Age since updated interval dimension described here

Lauma /

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Marketplace Apps & Integrations

Do Not Lose your Customer’s Trust

Missing deadlines is one of the biggest problems every team lead wants to avoid when dealing with managed services. When the customer contracts your company to help with IT services it is expected th...

340 views 0 2
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you