Can we get the Resolved Tickets from Backlog which are not created today

Questions & Answers
1

Hi Team,

Can we get the Resolved Tickets from the Backlog which are not created today in eazyBI.

Regards
Kasi

2

Hi @kasi.maddula

Is “Backlog” a status in your Jira?

If yes, then you could use the following formula to count the issues:

Count(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    (
      [Measures].[Issues resolved],
      [Status].[Backlog]
    ) > 0
    AND NOT
    DateInPeriod(
        [Measures].[Issue created date],
        [Time].[Day].CurrentDateMember
    )
  )
)

Let me know if this works as expected!
Cheers,
Nauris / eazyBI support