Sum the number of days in an specific state ['To Do', 'Blocked', 'In Progress', 'To Build', 'To Test', 'Testing', 'Done']

[hernan0216]

Hi, I'm using jira_to_analytics.js script to obtain the information about sprints and generate some stats. In the output file there is a set of columns that we use to estimate the time that a task was in an specific state, for example the columns 'To Do', 'Blocked', 'In Progress', 'To Build','To Test', 'Testing', 'Done', these fields are dates so I consider that de difference days = 'To Build' - 'In Progress', is the time that the task was in In progress states, but in case that the task moves from 'To Build' to 'In Progress' again for any reason, I lost the first amount of days that was 'In Progress' isn't accumulative. There is any solution for this? I want to consider that the time that a task was 'In Progress' is the sum() of the days that was 'In progress'. How can I implement these? I appreciate any help. Thanks

[hernan0216]

I'm using this config.yml file: Connection: Domain: XX Username: XX Password: XXX

  Criteria:
      Project:
          - X
          - Y
      Issue types: 
          - Story
          - Task
          - Bug

      JQL:

  Workflow:
      To Do:
        - To Do
      Blocked:
        - Blocked
      In Progress:
        - In Progress
      To Build:
        - To Build
      To Test:
        - To Test
      Testing:
        - Testing
      Done:
        - Done
      Invalid:
        - Invalid

  Attributes:
        Stage: status
        Type: issuetype
        Level: priority
        Labels: labels
        Versions: fixVersions
        Components: components
        Estimate: timeoriginalestimate
        Remaining: timeestimate
        Time: timespent
        Tracking: timetracking
        Points: customfield_10005