due to historical input we had to create 2 custom fields in Jira (start date and end date), because de start and/or end date was different from the timestamp.
So we created in EazyBi next:
[chosen start date]
IIf(IsEmpty([Measures].[Issue Start date (manualy)]),
[Measures].[Time stamp start date] ,
[Measures].[Issue Start date (manualy)])
[chosen end date]
IIf(IsEmpty([Measures].[Issue End date (manualy)]),
[Measures].[Time stamp end date] ,
[Measures].[Issue End date (manualy)])
Then we calculated the lead time [chosen end date]-[chosen start date]
What we now want to do is to calculate the average lead time for all the issues of a specific month they were closed, but the problem is that we don't get any data when we select all issues in "Individual members". We do get data when we select the issues in "all hierarchy level members".
So what I want is aggregated lead time / issues
Futhermore the custom date (is a [measure] not a [date]) doesn't respond when I use the time dimension.
what I need in the end is:
Yes, for individual issues this approach would work fine.
Though, when you want to get the issue count, as well as average, those conditions must be applied for each issue, and then calculate the average or total count over the set of those issues. It could be quite slow.
Then you may want to import those newly created custom fields Start date and End date as measures. As a result, you would get measures Issues with Start date and Issues with End date. Use Issues with End date for # issues row. Read more here: Measures with custom date fields
For the average calculation, you may want to iterate through all issues having this End date in the given time period, and then calculate the average day's difference between the start and end dates:
[Measures].[Issues with End date] > 0),
Then the average calculation would be simple, based on imported measures ([Measures].[Issues with end date] would be from End date custom field, while [Measures].[Duration with end date] - from both, Duration and End date):
[Measures].[Issues with end date]>0
[Measures].[Duration with end date]
[Measures].[Issues with end date]
Ilze / firstname.lastname@example.org