Count of issues created and resolved in the same period for current member

Questions & Answers
1

Hi Dears
how to define new calculated measure to count issues created and resolved in the same period for current PRO ID

image

2

Hi @ms.qattom
Welcome to the eazyBI Community!
Thanks for posting your question!
You might want to define a new calculated measure (Calculated measures) with the formula below. However, please double-check from your side whether you want to consider Issue Resolution date or the Issue closed date. In your request, you mention the resolved issues, but your table shows “Issues closed” (learn more about the Issues closed measure and which issues are considered here - Issues closed measure). If you want to include the “Issues closed”, please repace the Issue resolution date to “Issue closed date” in the formula below.

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateInPeriod(
      [Measures].[Issue created date],
      [Time].CurrentHierarchyMember) 
    AND
    DateInPeriod(
      [Measures].[Issue resolution date],
      [Time].CurrentHierarchyMember)
  ),
  [Measures].[Issues created] 
)

Best wishes,

Elita from support@eazybi.com

3

thank you a lot @Elita.Kalane

It is work well , but when i tried this measure for large count PRO ID always got timeout of 120 seconds message, is there any performance enhancement.

image

4

Hi @ms.qattom
To help you with the timeout error, could you please contact us directly at support@eazybi.com referring to this community post?
When you contact us, please export and share the definition for your eazyBI reports well
(Export and import report definitions).

Best wishes,

Elita from support@eazybi.com