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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

eazyBI "Issues closed" measure

I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Apr 25, 2023


After making a massive update of the value of a field on some issues, a project automation was triggered automatically.

The result is that the status of all these issues has changed to “Closed” (even though they were already “Closed”).

Now, when we generate the eazyBI report, using the measure "issues closed", we find all those issues closed on April 12.

My questions are:

  • Would it be possible to either recover the previous “Closed Date” or replace that date in all those issues? What’s the name of the field where the “Closed Date” is saved?
  • How could I achieve the same result (replicate the "Issues closed" measure) taking another date (Real End date) into account?reportDefectos.pngMeasuresDesarrollosEntregados.png 

Thanks and Regards


1 answer

0 votes
Gerda Grantiņa
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Apr 27, 2023

Hi @mfreirem

eazyBI considers "Issue closed date" as the last date when the issue transition to statuses that are defined as "Closed" in data source import options:

This field is defined only in eazyBI. 

You may want to use the issue's historical dimension and measures to get the date when the issue first transitioned to the status closed. Use this formula to create a new measure in the "Measure" dimension and get the first date as property:

([Measures].[Transition to status first date],

And use this formula to create a measure that you can use instead of "Issues closed". It will count issues by when they first transitioned to "Closed" status. 

    DescendantsSet([Issue].CurrentMember, [Issue].[Issue]),
        ([Measures].[Transition to status first date],
    [Measures].[Transitions to issues count]

Gerda //

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events