I’m new here and also new to EazyBI
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.
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.
Roberts // eazyBI support
It works now after importing SLA measures