Filter for all sprints with a start date greater than this year

Questions & Answers
1

I am trying to figure out how to build this calculated member to show me all sprints that have a start date after -2023-01-01. The business requirement is to show all the sprints in the sprint filter that started this year, so using the time dimension filter does not work as it does not cascade to the following filter to only show sprints in 2023

Monosnap eazyBI - JIRA 2023-02-02 13-00-17
Monosnap eazyBI - JIRA 2023-02-02 13-00-171820×902 132 KB

2

Hi @jeffb,

Date comparisons require particular functions in eazyBI and can’t be compared directly with mathematical comparison operators. In your case, I recommend using the Aggregate() function to group a set of Sprint dimension members. Then use the Filter() function to retrieve the Sprints that are started after the desired period. Finally, use the DateCompare() function to compare each Sprint start date with the threshold. The complete formula could look similar to the one below:

Aggregate(
  Filter(
    [Sprint].[Sprint].Members,
    DateCompare(
      [Sprint].CurrentMember.Get('Start date'),
      'Jan 1 2023'
    ) > 0
  )
)

Please refer to the eazyBI function reference for more details about the mentioned functions - MDX function reference.

Best,
Roberts // support@eazybi.com

3

thank you. one more question, how can i adjust this to be only sprints in a certain board

4

Hi @jeffb,

You can replace [Sprint].[Sprint].Members with [Sprint].[BOARD_NAME].Children in the calculated measure formula. Use the certain board’s name instead of BOARD_NAME.

Best,
Roberts // support@eazybi.com