4 Week Rolling report with Status

Questions & Answers
1

Hello Everyone

I am working on a four week status report to be shown to the business leaders on support request.
We have 4 issue type, Incident , Service Request, Enhancement and Defect
I can get the count for a given week, how many tickets were created, resolved and cancelled.
The challenge is getting the opening balance, by this what i meean is, at the start of the week, how many tickets were open (In Progress, To Do, In Dev , etc.)
Any guidance on how can the opening balance be calculated in eazyBI will be helpful.

In JQL i can create a formula with “Was In” to get the number.

Screenshot 2024-07-05 at 6.32.07 PM
Screenshot 2024-07-05 at 6.32.07 PM1396×994 101 KB

Thanks
JK

2

Seeking the guidance of Community here. Is this possible in eazyBI?

I have reached out to the eazyBI Support and no response.
We are using enterprise edition of jira and the support has been very poor from the eazyBI team.

3

Could it be something like this?

image
image1970×1274 248 KB

And the Dimensions used are:

image
image1272×1099 117 KB

“Total” is selected for both (Rows and cols)
Now, if you want to clean it a little bit you can do a right click on “Last 4 weeks” to Remove it (hide it) and in the “Flow Items”, or the name you want to use it.
Now the defined formulas are:

  • “Flow Items” in my report is a definition created for us but for your request will be this definition inside the “Issue Type”:
Aggregate({
  [Issue Type].[Incident],
  [Issue Type].[Request],
  [Issue Type].[Defect],
  [Issue Type].[Enhancement]
  }
)
  • The “Close Rejected” I guess it is depending on the Resolution, I have created this formula as:
([Measures].[Issues resolved],
[Resolution].[False issues])
  • The “False Issues” is this aggregation:
[Resolution].[Won't Fix] +
[Resolution].[Duplicate] +
[Resolution].[Incomplete] +
[Resolution].[Cannot Reproduce] +
[Resolution].[Won't Do]
4

Hello @Javed_Khan,

Apologies for the delay.

If you need to see the Issues in the last 4 weeks, you can create a new calculated member in the Time dimension: Calculated members in Time dimension

Aggregate( [Time.Weekly].[Week].DateMembersBetween(‘4 weeks ago’, ‘today’) )

Once you have created this calculated member, you can use it in Pages as a filter:

image.png
image.png1642×602 52.2 KB

You can then select different measures, e.g., “Open issues,” that will show the number of unresolved issues at the end of the corresponding Time dimension period, “Issues created”, “Issues resolved”, and others.

You can read more about measures & dimensions in our documentation here: Jira Core measures and dimensions
Time dimension: Time dimension

Please note that if your “canceled” tickets do not have a resolution date in Jira, they will be considered “unresolved” and therefore “Open”. To solve this, you can either change the workflow in Jira for canceled tickets, or, if this is not possible, define which statues should be considered as closed in eazyBI import options. Once you do that, you will need to create a new calculated measure to count all the “non closed” issues.

My colleague Martins is describing how to solve this situation in a community post here: Open Issues measure

I hope this helps,
Marita / support@eazybi.com