Help Age Interval

I know that the Age interval calculates the time from the moment of creation to the present day. But would there be any way to make a new calculation for him to do this account excluding weekends?

I’m looking for this because the measures that I have pre-defined are not working correctly, they don’t bring any data.
Can you please help me with a calculation that meets the need to count the age interval excluding weekends?

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:

    -- is not resolved
    IsEmpty([Issue].CurrentHierarchyMember.Get('Resolved at'))
    -- less than ten workdays since created
      [Issue].CurrentHierarchyMember.Get('Created at'),
    ) <= 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.


1 Like