Creating a "True" month by month SLA - help needed please

Hi,

I’m trying to create a report to show a monthly SLA, that will only include the issues created in that month, not the issues that were resolved in that month.

For example if I was to filter to “March 2023”, I would want to see tickets created in that month. If they breached SLA or not, and the totals/%s for that month.

I can only get eazybi to show “all” issues resolved in the month, instead of just the issues that were created in that month.

1 Like

Hi @Terry86

You would need a new calcualted measure for that.

Please this formula with integer formatting for output to calculate issues resolved if they were also created in the same period for the report.

Sum(
Filter(
DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
DateInPeriod(
  [Measures].[Issue created date],
  [Time].CurrentHierarchyMember
)
),
[Measures].[Issues resolved]
)

But it might be slow to calculate this result as this formula itereats through all imported issues for each report row. If you want to try optimized calculation, please export and share the definition of your report or contact support@eazybi.com

Martins / eazyBi