Hi @CarolDesideri,
Welcome to the eazyBI community!
You can explore two options. The first option is defining calculated measures for each interval, iterating through issues. For example, the formula for one such calculated measure could look similar to the one below:
Sum(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
-- is not resolved
IsEmpty([Issue].CurrentHierarchyMember.Get('Resolved at'))
AND
-- less than ten workdays since created
DateDiffWorkdays(
[Issue].CurrentHierarchyMember.Get('Created at'),
'today'
) <= 10
),
[Measures].[Issues created]
)
The example will look for unresolved issues ten days old or less. This can turn out to be a significant burden on report execution if you have a lot of issues or create several such calculations in one report. See more details on calculated measures here - Calculated measures and members.
The other option is defining a JavaScript calculated custom field that calculates the result upon data import instead of report execution. There is an option to import such a field as an interval dimension. Please see one such option on our documentation page - JavaScript calculated custom fields. Unfortunately, I don’t have an example of calculating the difference in workdays.
Best,
Roberts support@eazybi.com