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
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.