MTTR based on start and end date

Questions & Answers
1

Hi!
I’m trying to calculate the MTTR using the start and end date rather than the created and resolution dates. I know I have to import those custom fields but I can’t find them in the database / Custom fields even though I have them on Jira. Is there a JS script necessary?

Thank you :slight_smile:

2

Hi @Thibault ,

Thanks for posting your question!
Usually for Jira Standard date fields, eazyBI should recognize the fields automatically.
Here are possible scenarios you could try:

  1. Did you check the Add-on tab to see if the fields are a part of some of the Add-ons?
  2. Could this potentially be an integrated field from another app (for example Scriptrunner field?)
    In such case, you might try defining the field through the eazyBI advanced settings (Advanced settings for custom fields) The JS code might look as the code below where NNNNN is the ID of your field Start Time (or End Time). Then proceed to the Import options and select "Start Time’ for import. Do the same for End Time.
[jira.customfield_NNNNN]
name = "Start Time"
data_type = "datetime"
measure = true

Best wishes,

Elita from support@eazybi.com