New to EazyBI, need to calculate date between two issues

Questions & Answers
1

Hi all,

I’m very new to EazyBI and I want to get better at it. I have 2000+ issues on my board and I want to see how long it took for the users of my board to create issues between 1000 and 2000 - what was the time between issue ABC-1000 and ABC-2000?

How do I do it in the easiest way? :slight_smile:

2

Hi @RobertR1234,

Welcome to eazyBI! :slightly_smiling_face:

You can create a new calculated measure using the DateDiffDays function combined with GetMemberByKey to get the creation dates of the two specific issues:

DateDiffDays(
  [Issue].[Issue].GetMemberByKey('ABC-1000').Get('Created at'),
  [Issue].[Issue].GetMemberByKey('ABC-2000').Get('Created at')
)

This will return the number of days between the creation of issue ABC-1000 and ABC-2000. Just replace the issue keys with your actual project keys if they differ.

If you are new to eazyBI, I also highly recommend taking a look at the Learning lessons that cover the introduction to eazyBI & MDX.

I hope this helps!

Best,
Marita from support@eazybi.com

1 Like