Tracking a custom field by shift

Questions & Answers
1

I am looking to track an alphanumeric custom field called work order #. My goal is to track all work orders where the time to resolution was breached per shift for 2023 per quarter:

Q1
9-6p: X breached issues with work orders
5-2a: X breached issues with work orders
1-10a: X breached issues with work orders

Q2
9-6p: X breached issues with work orders
5-2a: X breached issues with work orders
1-10a: X breached issues with work orders

Q3
9-6p: X breached issues with work orders
5-2a: X breached issues with work orders
1-10a: X breached issues with work orders

Q4
9-6p: X breached issues with work orders
5-2a: X breached issues with work orders
1-10a: X breached issues with work orders

please let me know if any more detail is needed

2

Hi @Danimal,

Welcome to the eazyBI community!

You can select your custom field for import in the eazyBI import options “Custom fields” tab - Jira custom fields.

Unfortunately, eazyBI doesn’t offer the date or time the SLA was breached. The SLA-specific measures “SLA issues” and “SLA - Breached” will return a value on the Time dimension on the day the SLA cycle was completed and not when it was breached.

You can look into the JavaScript calculated custom field option, but I don’t have any examples - JavaScript calculated custom fields.

Best,
Roberts // support@eazybi.com