Coding to pull number of resolved cases whom met criteria

Hello everyone!

I’m new here and also new to EazyBI :slight_smile:

Here’s a question I need help with:
Currently at my workplace we’re using Jira Service Desk with EazyBI as an add-on.
My task is to pull out data for:

  • Number of cases where resolved issue is within the given resolution time

With this in mind, I tried with codes like DateDiffDays etc. and it just couldn’t work.
Thus, I am seeking help here if anyone knows what to write into the “user defined calculated member formula”.

To simply this case, my desired outcome should follow something like:
When [Resolved Issue] > 0 Then
When Difference of [Created Date] & [Resolution] <= 7 Days Then
[SLA Resolution] + 1

Thanks everyone! :slight_smile:

Hi @ryantan,

Welcome to the eazyBI community. If you have the resolution time in Jira Service desk as an SLA, you have the option to import each SLA as a measure in the eazyBI import settings. Once you have done that, you can use then these measures. For the SLA “Time to resolution”, the measure will be “Time to resolution - Met”.
Please read more about the eazyBI and Jira Service desk integration on the documentation page - https://docs.eazybi.com/eazybijira/data-import/data-from-jira-and-apps/jira-service-desk-custom-fields.

If it is not an SLA, you can try to make use of the resolution interval dimension. Please have a look at this eazyBI community post for more information - Report containing the number of solved issues grouped by number of resolution days.

Kind regards,
Roberts // eazyBI support

1 Like

Thanks @roberts.cacus!
It works now after importing SLA measures :slight_smile: