Create report to show daily open ticket count for past rolling 30 days

Questions & Answers
1

Hi all,

The subject sums it up really. I’m just getting started with EazyBi, using it to interrogate data from Jira Service Management.

I’m looking to build a report to show the number of open tickets (In Progress, Waiting for support, Pending) at the end of each day. I can’t see anywhere this question has been asked before, so apologies if it has been.

Thanks

2

ey!
Maybe this report as an example is what you are looking for, the “CFD - Cumulative Flow Diagram”, But without selecting the “Done” Category:
https://eazybi.com/accounts/1000/cubes/Issues/reports/187032-cumulative-flow-diagram
Where maybe the filter assignee you don’t need it.

The important part here is the Dimension “Transition Status” where it is aggregated the status by Category and if you want to Redefine it, to remove the Done Category. you can create something like this:


Aggregate(
  Except(
    -- addresses members of a particular level only
    [Transition Status].[Transition Status].Members, 
    {[Transition Status].[Closed],
    [Transition Status].[Resolved],
    [Transition Status].[ANY OTHER FINAL STATUS YOU HAVE...]
    
     }
  )
)
3

Hello @Bionic ,
Welcome to the eazyBI community!
One option is to use @Nacho’s suggestion —measure “Issues history” with “Transition status” members that you are interested in. Then, filter the report by the “Time” dimension “Last 30 days.”
You can also use the measure “Open issues,” which calculates the number of unresolved issues at the end of the corresponding Time dimension period. Using this measure with the Time dimension set to Days will give you the daily open ticket count you’re looking for.

Kind regards,
Gerda // support@eazybi.com