Hello Community, I am trying to set up a report in easyBI to demonstrate the few KPIs below based on Sample Report “Created vs resolved issues over time” Our JIRA projects have the status defined on each tickets New Under Analysis Analysis Done Integration Closed KPI1. Total amount of “Active T…

Hi, Try combining both codes into one calculated measure: CASE WHEN ( [Measures].[Issues history], [Transition Status].[Open Issues(New&Analysis)] ) > 0 THEN Avg( Filter(Descendants([Issue].CurrentMember, [Issue].[Issue]), -- filter open issues in period using issue properties Created …

List "Active Tickets" in easyBI

Questions & Answers

martins.vanags June 9, 2022, 2:55pm 11

@steve_bolan

In your case, perhaps another community post can be useful

Martins / eazyBI