# Create formula for unplanned parallel work

**URL:** <https://community.eazybi.com/t/create-formula-for-unplanned-parallel-work/19930>\
**Category:** Questions & Answers\
**Tags:** jira, sprint\
**Created:** [April 30, 2025, 9:26am UTC](https://community.eazybi.com/t/create-formula-for-unplanned-parallel-work/19930 "2025-04-30T09:26:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![aditya.verma](https://community.eazybi.com/letter_avatar_proxy/v4/letter/a/fbc32d/32.png) [@aditya.verma](https://community.eazybi.com/u/aditya.verma)\
**Post date:** [April 30, 2025, 9:26am UTC](https://community.eazybi.com/t/create-formula-for-unplanned-parallel-work/19930/1 "2025-04-30T09:26:41Z")

</div>

Hi,

I am trying to build a formula that take active sprint value and component value from filter and shows count of tickets which have the same component and were updated during the dates of the selected sprint but has the sprint value as empty.

So basically it gives me tickets which were being worked upon during the sprint but were not included in the sprint. I have created below formula but it is not giving me results. I receive “mmm dd yyyy” as output. Please help in achiving the desired results.

JQL example:  
project = “ABC” AND updated \>= ‘2025-04-16’ AND updated \<= ‘2025-04-29’ AND component = Tech AND Sprint is EMPTY  
In above JQL I am adding the sprint dates manually but MDX should obtain these date values from the selected sprint in filter.

MDX formula:

Count(  
Filter(  
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),  
– Filter issues updated during the selected sprint’s date range  
DateCompare(  
[Measures].[Issue updated date],  
[Sprint].CurrentHierarchyMember.Get(‘Start date’)  
) \>= 0  
AND  
(  
IsEmpty([Sprint].CurrentHierarchyMember.Get(‘End date’))  
OR  
DateCompare(  
[Measures].[Issue updated date],  
[Sprint].CurrentHierarchyMember.Get(‘End date’)  
) \<= 0  
)  
AND  
– Filter by component selected in filter  
[Measures].[Issue components] MATCHES  
[Component].CurrentHierarchyMember.Name  
AND  
– Filter issues with no sprint value  
IsEmpty([Measures].[Issue Sprint])  
)  
)

Thanks in Advance!

---

<div class="post-metadata">

**Author:** ![nauris.malitis](https://community.eazybi.com/user_avatar/community.eazybi.com/nauris.malitis/32/6355_2.png) [@nauris.malitis](https://community.eazybi.com/u/nauris.malitis)\
**Post date:** [May 8, 2025, 3:02pm UTC](https://community.eazybi.com/t/create-formula-for-unplanned-parallel-work/19930/2 "2025-05-08T15:02:44Z")

</div>

Hi @aditya.verma

I’ll share here the same formula that I shared in the email:

```auto
Sum(
  Filter(
    Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    -- Filter issues updated during the selected sprint's date range
    DateBetween(
      [Measures].[Issue updated date],
      [Sprint].CurrentHierarchyMember.Get('Start date'),
      -- use Sprint actual end date, if there is none, then planned end date, if there is none then Now()
      CoalesceEmpty(
        [Sprint].CurrentHierarchyMember.Get('Complete date'),
        [Sprint].CurrentHierarchyMember.Get('End date'),
        Now()
      )
    )
  ),
  CASE WHEN
    -- if the issue has no sprints
    [Measures].[Issue Sprint] = "(no sprint)"
  THEN
    -- return the count of the issue (this will match with the component as well)
    (
      [Measures].[Issues last updated],
      [Sprint].CurrentHierarchy.DefaultMember
    )
  END
)

```

Be sure to set the Formatting to Numeric → Integer to see numeric values instead of “mmm dd yyyy”

​Best regards,  
​Nauris