sprint_features.yml

path: sprint_features
categories:
    general:
        nl: Algemeen
        en: General
        icon: [fas, fa-project-diagram]
    team:
        nl: Team
        en: Team
        icon: [fas, fa-users]
    metrics:
        nl: Metrieken
        en: Metrics
        icon: [fas, fa-chart-pie]
    tracking:
        nl: Voortgang
        en: Progress
        icon: [fas, fa-tasks]
    velocity:
        nl: Velocity
        en: Velocity
        icon: [fas, fa-shipping-fast]
    backlog:
        nl: Backlog
        en: Backlog
        icon: [fas, fa-clipboard-list]
    code:
        nl: Code
        en: Code
        icon: [fas, fa-server]
files:
  - expression: '1:length(get(ls()[1]))'
    window:
        dimension: 1
        group: project_id
    column: sprint_num
    optional: No
    combine: min
    descriptions:
        nl: Sprintnummer
        en: Sprint number
    long_descriptions:
        nl: Het opeenvolgende nummer van de sprint in de loopduur van het project
        en: The sequential number of the sprint in the project's lifespan
    units:
        nl: "Sprint #%s"
        en: "Sprint #%s"
    measurement:
        unit: meta
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=burndownChart&sprint=${jira_sprint_id}"
        jira_version: "${jira_url}/jira/projects/${jira_key}?selectedItem=com.atlassian.jira.jira-projects-plugin%3Arelease-page&status=released-unreleased"
    category: general
  - definition: sprint_days
    table: sprint
    column: sprint_days
    optional: No
    combine: median
    descriptions:
        nl: Sprintlengte
        en: Sprint length
    long_descriptions:
        nl: Het aantal dagen tussen de begindatum en de einddatum van de sprint
        en: The number of days between the start and end date of the sprint
    units:
        nl: "%s dagen"
        en: "%s days"
    short_units:
        nl: "%s dagen"
        en: "%s days"
    measurement:
        unit: time
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
        jira_version: "${jira_url}/jira/projects/${jira_key}/versions/${jira_sprint_id}"
    category: general
  - definition: sprint_weekdays
    table: sprint
    column: sprint_weekdays
    combine: median
    descriptions:
        nl: Weekdagen
        en: Week days
    long_descriptions:
        nl: Het aantal dagen exclusief weekends tussen de begindatum en de einddatum van de sprint
        en: The number of days, excluding weekends, between the start and end date of the sprint
    units:
        nl: "%s weekdagen"
        en: "%s weekdays"
    short_units:
        nl: "%s dagen"
        en: "%s days"
    measurement:
        unit: time
        superset: sprint_days
    preferred: true
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
        jira_version: "${jira_url}/jira/projects/${jira_key}/versions/${jira_sprint_id}"
    category: general
  - filename: 00-sprint-closed.sql
    table: sprint_close
    column: sprint_is_closed
    optional: No
    combine: min
    descriptions:
        nl: Gesloten sprint
        en: Closed sprint
    long_descriptions:
        nl: Of de sprint op het moment afgesloten is
        en: Whether the sprint is closed at the moment
    tags:
        nl: Gesloten
        en: Closed
    units:
        nl: "%s gesloten sprint"
        en: "%s closed sprint"
    measurement:
        unit: meta
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
        jira_version: "${jira_url}/jira/projects/${jira_key}?selectedItem=com.atlassian.jira.jira-projects-plugin%3Arelease-page&status=released-unreleased"
    category: general
  - expression: "1 - sprint_is_closed"
    column: sprint_is_open
    optional: No
    combine: max
    descriptions:
        nl: Open sprint
        en: Open sprint
    long_descriptions:
        nl: Of de sprint op het moment open staat
        en: Whether the sprint is open at the moment
    tags:
        nl: Open
        en: Open
    units:
        nl: "%s open sprint"
        en: "%s open sprint"
    measurement:
        unit: meta
    category: general
  - filename: 00-sprint-gathered.sql
    table: sprint_gathered
    column: sprint_is_complete
    optional: No
    combine: min
    descriptions:
        nl: Complete sprint
        en: Complete sprint
    long_descriptions:
        nl: Of alle gegevens beschikbaar zijn voor de sprint
        en: Whether all data is available for the sprint
    tags:
        nl: Compleet
        en: Complete
    units:
        nl: "%s complete sprint"
        en: "%s complete sprint"
    measurement:
        unit: meta
    category: general
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
        jira_version: "${jira_url}/jira/projects/${jira_key}?selectedItem=com.atlassian.jira.jira-projects-plugin%3Arelease-page&status=released-unreleased"
  - filename: 01-number-of-vcs-committers.sql
    table: sprint_vcs_dev_count
    column: number_of_vcs_devs
    default: 0
    combine: mode
    descriptions:
        nl: Developer teamgrootte
        en: Development team size
    long_descriptions:
        nl: Het aantal developers dat commits in het versiebeheersysteem maakt tijdens de sprint
        en: The number of developers that made commits in the version control system during the sprint
    units:
        nl: "%s developers"
        en: "%s developers"
    short_units:
        nl: "%s devs"
        en: "%s devs"
    measurement:
        unit: person
    source:
        vcs: "${vcs_url}"
    category: team
  - filename: 01-number-of-jira-updaters.sql
    table: sprint_jira_dev_count
    column: number_of_jira_devs
    default: 0
    combine: mode
    descriptions:
        nl: Project teamgrootte
        en: Project team size
    long_descriptions:
        nl: Het aantal personen dat aanpassingen maakt in de projecttracker tijdens de sprint
        en: The number of persons that made changes in the project tracker during the sprint
    units:
        nl: "%s projectleden"
        en: "%s project members"
    short_units:
        nl: "%s leden"
        en: "%s members"
    measurement:
        unit: person
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?projectKey=${jira_key}&rapidView=${jira_board_id}&view=planning"
    category: team
    cache: true
  - filename: 01-number-of-seats.sql
    table: sprint_seat_count
    column: number_of_seats
    default: 0
    combine: median
    descriptions:
        nl: Teamgrootte
        en: Team size
    long_descriptions:
        nl: Het aantal fte voor het project in de periode van de sprint
        en: The number of FTE for the project during the sprint period
    units:
        nl: "%s full-time leden"
        en: "%s fulltime members"
    short_units:
        nl: "%s fte"
        en: "%s FTE"
    measurement:
        unit: person
    category: team
  - expression: "ifelse(number_of_vcs_devs > 0, number_of_vcs_devs, round(mean(c(number_of_jira_devs, number_of_seats))))"
    column: number_of_devs
    default: 0
    combine: mode
    descriptions:
        nl: Aantal developers
        en: Number of developers
    long_descriptions:
        nl: Het berekende aantal developers in het project tijdens de sprint
        en: The calculated number of developers in the project during the sprint
    units:
        nl: "%s developers"
        en: "%s developers"
    short_units:
        nl: "%s devs"
        en: "%s devs"
    measurement:
        unit: person
    preferred: true
    category: team
  - filename: 01-dev-sprint-experience.sql
    table: sprint_experience
    column: dev_sprint_experience
    default: 0
    combine: mean
    descriptions:
        nl: Teamervaring
        en: Team experience
    long_descriptions:
        nl: Het totaal aantal sprints waar developers in gewerkt hebben in de loopduur van het project voor de sprint
        en: The total number of sprints that developers have worked in the lifespan of the project before the sprint
    units:
        nl: "%s sprints ervaring"
        en: "%s sprints of experience"
    short_units:
        nl: "%s sprints"
        en: "%s sprints"
    measurement:
        unit: sprint
    category: team
    source:
        vcs: "${vcs_url}"
    cache: true
  - expression: "dev_sprint_experience / number_of_devs"
    column: weighted_sprint_experience
    default: 0
    combine: median
    descriptions:
        nl: Gemiddelde ervaring
        en: Average experience
    long_descriptions:
        nl: Het aantal sprints dat een developer in het team gemiddeld in heeft gewerkt in de loopduur van het project voor de sprint
        en: The number of sprints that a developer in the team has worked in the lifespan of the project before the sprint
    units:
        nl: "%s sprints ervaring per developer"
        en: "%s sprints of experience per developer"
    short_units:
        nl: "%s sprints/dev"
        en: "%s sprints/dev"
    measurement:
        unit: [sprint, person]
        dividend: dev_sprint_experience
        divisor: number_of_devs
    category: team
  - filename: 01-new-committers.sql
    table: new_developers
    column: num_new_developers
    default: 0
    combine: sum
    descriptions:
        nl: Nieuwe developers
        en: New developers
    long_descriptions:
        nl: Het aantal developers die niet eerder gewerkt hebben in de loopduur van het project voor de sprint
        en: The number of developers that have not worked on the project during its lifespan before the sprint
    units:
        nl: "%s nieuwe developers"
        en: "%s new developers"
    measurement:
        unit: person
        superset: number_of_devs
    category: team
    source:
        vcs: "${vcs_url}"
    cache: true
  - metric: TeamSpirit
    column: team_spirit
    aggregate: end
    combine: mode
    descriptions:
        nl: Teamstemming
        en: Team spirit
    long_descriptions:
        nl: De stemming van het team tijdens de sprint
        en: The mood of the team during the sprint
    values:
        type: icon
        icons:
            0: [far, fa-frown]
            1: [far, fa-meh]
            2: [far, fa-grin]
    units:
        nl: "Stemming van %s"
        en: "Spirit %s"
    measurement:
        unit: meta
    source:
        quality: "${quality_url}/${quality_name}"
        metric_history: "${metric_history_url}/${metric_history_file}"
  - metric: [ProductLOC, Ncloc, loc]
    column: lines_of_code
    carry: True
    aggregate: end
    summarize: sum
    combine: sum
    descriptions:
        nl: Aantal regels code
        en: Number of lines of code
    long_descriptions:
        nl: Het totaal aantal regels code in de producten aan het einde van de sprint
        en: The total number of lines of code in the products at the end of the sprint
    units:
        nl: "%s regels code"
        en: "%s regels code"
    measurement:
        unit: line
    backends: [sonar]
  - metric: [UnittestLineCoverage, LineCoverage]
    column: unittest_line_coverage
    carry: True
    aggregate: end
    summarize: [min, max]
    combine: [min, max]
    descriptions:
        nl: Unittest line coverage
        en: Unittest line coverage
    long_descriptions:
        nl: Het percentage regels met code dat in de producten door tests wordt bereikt aan het einde van de sprint
        en: The percentage of lines of code in the products that is reached by tests at the end of the sprint
    units:
        nl: "%s%% unittest line coverage"
        en: "%s%% unittest line coverage"
    short_units:
        nl: "%s%%"
        en: "%s%%"
    measurement:
        unit: [line, line]
        dividend: number_of_covered_lines
        divisor: lines_of_code
    backends: [sonar]
  - metric: [UnittestBranchCoverage, BranchCoverage]
    column: unittest_branch_coverage
    carry: True
    aggregate: end
    summarize: [min, max]
    combine: [min, max]
    descriptions:
        nl: Unittest branch coverage
        en: Unittest branch coverage
    measurement:
        unit: [line, line]
        dividend: number_of_covered_branches
        divisor: number_of_branches
    long_descriptions:
        nl: Het percentage regels met condities dat in de producten door tests wordt bereikt aan het einde van de sprint
        en: The percentage of lines of conditions in the products that is reached by tests at the end of the sprint
    units:
        nl: "%s%% unittest branch coverage"
        en: "%s%% unittest branch coverage"
    short_units:
        nl: "%s%%"
        en: "%s%%"
    backends: [sonar]
  - metric: ARTStatementCoverage
    column: art_statement_coverage
    aggregate: end
    summarize: [min, max]
    combine: [min, max]
    descriptions:
        nl: ART statement coverage
        en: ART statement coverage
    long_descriptions:
        nl: Het percentage regels met statements dat in de producten door regressietests wordt bereikt aan het einde van de sprint
        en: The percentage of lines of statements in the products that is reached by regression tests at the end of the sprint
    units:
        nl: "%s%% ART statement coverage"
        en: "%s%% ART statement coverage"
    short_units:
        nl: "%s%%"
        en: "%s%%"
    measurement:
        unit: [line, line]
        dividend: number_of_covered_lines
        divisor: lines_of_code
    backends: [sonar]
  - metric: ARTBranchCoverage
    column: art_branch_coverage
    aggregate: end
    summarize: [min, max]
    combine: [min, max]
    descriptions:
        nl: ART branch coverage
        en: ART branch coverage
    long_descriptions:
        nl: Het percentage regels met condities dat in de producten door regressietests wordt bereikt aan het einde van de sprint
        en: The percentage of lines of condities in the products that is reached by regression tests at the end of the sprint
    units:
        nl: "%s%% ART branch coverage"
        en: "%s%% ART branch coverage"
    short_units:
        nl: "%s%%"
        en: "%s%%"
    measurement:
        unit: [line, line]
        dividend: number_of_covered_branches
        divisor: number_of_branches
    backends: [sonar]
  - metric: [Vulnerabilities]
    column: vulnerabilities
    carry: true
    aggregate: end
    summarize: sum
    descriptions:
        nl: Kwetsbaarheden
        en: Vulnerabilities
    long_descriptions:
        nl: Het aantal gedetecteerde plekken in code in de producten die wellicht voor kwetsbaarheden zorgen aan het einde van de sprint
        en: The number of detected locations in code in the products that may cause vulnerabilities at the end of the sprint
    units:
        nl: "%s kwetsbaarheden"
        en: "%s vulnerabilities"
    measurement:
        unit: issue
    backends: [sonar]
  - metric: MaintainabilityBugs
    column: maintainability_bugs
    carry: true
    aggregate: end
    summarize: sum
    descriptions:
        nl: Onderhoudsbugs
        en: Maintainability bugs
    long_descriptions:
        nl: Het aantal gedetecteerde plekken in code in de producten die er wellicht voor zorgen dat onderhoud wordt bemoeilijkt aan het einde van de sprint
        en: The number of detected locations in code in the products that may cause hindrance to maintainability at the end of the sprint
    units:
        nl: "%s onderhoudsbugs"
        en: "%s maintainability bugs"
    measurement:
        unit: issue
    backends: [sonar]
  - metric: CodeSmells
    column: code_smells
    carry: true
    aggregate: end
    summarize: sum
    descriptions:
        nl: Code smells
        en: Code smells
    long_descriptions:
        nl: Het aantal gedetecteerde plekken in code in de producten die wellicht niet voldoen aan designprincipes aan het einde van de sprint
        en: The number of detected locations in code in the products that may not adhere to design principles at the end of the sprint
    units:
        nl: "%s code smells"
        en: "%s code smells"
    measurement:
        unit: issue
    backends: [sonar]
  - metric: SqaleIndex
    column: technical_debt
    carry: true
    aggregate: end
    summarize: sum
    descriptions:
        nl: Technische schuldtijd
        en: Technical debt time
    long_descriptions:
        nl: De hoeveelheid tijd die ingeschat wordt om problemen omtrent technische schuld in code in de producten op te lossen aan het einde van de sprint
        en: The amount of time that is estimated to resolve technical debt issues in code in the products at the end of the sprint
    values:
        type: duration
        intervals:
            - unit: minutes
              key: m
              num: 60
            - unit: hours
              key: h
              num: 8
            - unit: days
              key: d
              num: 5
    units:
        nl: "%s technische schuld"
        en: "%s of technical debt"
    measurement:
        unit: time
    backends: [sonar]
  - metric: [DocumentAge, source_up_to_dateness]
    column: document_age
    aggregate: end
    summarize: [min, max]
    combine: [min, max]
    descriptions:
        nl: Documentouderdom
        en: Document age
    long_descriptions:
        nl: De hoeveelheid tijd dat de documenten niet zijn aangepast aan het einde van de sprint
        en: The amount of time that the documents have not been updated at the end of the sprint
    values:
        type: duration
        intervals:
            - unit: days
              key: d
              num: 5
    units:
        nl: "%s geleden bijgewerkt"
        en: "%s last updated"
    measurement:
        unit: time
    backends: [git, github, gitlab, tfs, subversion]
  - filename: 03-story-watchers.sql
    table: watchers
    column: num_watchers
    default: 0
    combine: mean
    descriptions:
        nl: Story-watchers
        en: Story watchers
    long_descriptions:
        nl: Het gemiddeld aantal personen dat notificaties van aanpassingen aan een story in de sprint ontvangt
        en: The average number of persons that receive notifications of changes to a story in the sprint
    units:
        nl: "%s story-watchers"
        en: "%s story watchers"
    measurement:
        unit: person
        superset: number_of_jira_devs
    source:
        jira: "${jira_url}/secure/IssueNavigator.jspa?jqlQuery=${jira_project} and ${jira_sprint} and type = Story and watchers %3E 0&runQuery=true"
    category: tracking
  - filename: 03-number-of-issue-changers.sql
    table: updaters
    column: avg_updaters
    default: 0
    combine: mean
    descriptions:
        nl: Item-updaters
        en: Item updaters
    long_descriptions:
        nl: Het gemiddeld aantal personen dat een aanpassing aan een item in de sprint maakt
        en: The average number of persons that makes a change to an item in the sprint
    units:
        nl: "%s item-updaters"
        en: "%s item updaters"
    measurement:
        unit: person
        superset: number_of_jira_devs
    category: tracking
    source:
        jira: "${jira_url}/secure/IssueNavigator.jspa?jqlQuery=${jira_project} and ${jira_sprint} and reporter !%3D currentUser()&runQuery=true"
    cache: true
  - filename: 04-expected-story-points.sql
    table: expected_story_points
    column: num_story_points
    patterns:
        story_point_types: NOT (${s(issue_bug)})
    default: 0
    summarize:
        operation: sum
        field: story_points
        details: [key, story_points]
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Geplande storypoints
        en: Planned story points
    long_descriptions:
        nl: Het totaal aantal storypoints voor 1 dag na de start van sprint is gepland
        en: The total number of story points that is planned at most 1 day after the sprint starts
    units:
        nl: "%s geplande punten"
        en: "%s planned points"
    measurement:
        unit: point
        moment: [1, days]
        post: done_story_points
    preferred: true
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=burndownChart&sprint=${jira_sprint_id}"
    cache: true
    category: velocity
  - filename: 04-done-story-points.sql
    table: done_story_points
    column: done_story_points
    patterns:
        story_point_types: NOT (${s(issue_bug)})
    default: 0
    summarize:
        operation: sum
        field: story_points
        details: [key, story_points, fixversion]
    combine: sum
    prediction:
        - url: '${prediction_url}'
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Afgeronde storypoints
        en: Done story points
    long_descriptions:
        nl: Het totaal aantal storypoints dat voltooid is in de sprint
        en: The total number of story points that are completed during the sprint
    units:
        nl: "%s afgronde storypoints"
        en: "%s done story points"
    measurement:
        unit: point
        superset: velocity_one
        moment: post
        pre: num_story_points
    preferred: true
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    cache: true
    category: velocity
  - filename: 04-expected-story-points.sql
    table: expected_bug_points
    column: planned_bug_points
    patterns:
        story_point_types: ${s(issue_bug)}
    default: 0
    summarize:
        operation: sum
        field: story_points
        details: [key, story_points]
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Geplande bug points
        en: Planned bug points
    long_descriptions:
        nl: Het totaal aantal storypoints voor bugs die voor 1 dag na de start van sprint zijn gepland
        en: The total number of points for bugs that are planned at most 1 day after the sprint starts
    units:
        nl: "%s geplande bug punten"
        en: "%s planned bug points"
    measurement:
        unit: point
        moment: [1, days]
        post: done_bug_points
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=burndownChart&sprint=${jira_sprint_id}"
    category: velocity
  - filename: 04-done-story-points.sql
    table: done_bug_points
    column: done_bug_points
    patterns:
        story_point_types: ${s(issue_bug)}
    default: 0
    summarize:
        operation: sum
        field: story_points
        details: [key, story_points]
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Afgeronde bug points
        en: Done bug points
    long_descriptions:
        nl: Het totaal aantal storypoints voor bugs die voltooid zijn in de sprint
        en: The total number of points for bugs that are completed during the sprint
    units:
        nl: "%s afgronde bug points"
        en: "%s done bug points"
    measurement:
        unit: point
        superset: velocity_one
        moment: post
        pre: planned_bug_points
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    category: velocity
  - expression: "done_story_points + done_bug_points"
    column: velocity_one
    default: 0
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: "Sprint-velocity"
        en: "Sprint velocity"
    long_descriptions:
        nl: "Het totaal aantal storypoints die voltooid zijn in de sprint"
        en: "The total number of points that are completed during the sprint"
    units:
        nl: "%s punten"
        en: "%s points"
    measurement:
        unit: point
    source:
        jira: null
    category: velocity
  - expression: "done_story_points - num_story_points"
    column: over_expectation
    default: 0
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Punten boven verwachting
        en: Points above expectation
    long_descriptions:
        nl: Het aantal storypoints die tijdens de sprint zijn afgemaakt terwijl ze niet gepland zijn
        en: The number of story points that are completed during the sprint despite not being planned
    units:
        nl: "%s toegevoegde storypoints"
        en: "%s added story points"
    measurement:
        unit: point
        superset: done_story_points
    preferred: false
    source:
        jira: null
    category: velocity
  - expression: "abs(done_story_points - num_story_points)"
    column: points_off_expectation
    default: 0
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Punten naast verwachting
        en: Points off expectation
    long_descriptions:
        nl: Het aantal storypoints afgemaakt tijdens de sprint onder of boven de geplande aantal
        en: The number of story points completed during the sprint above or below the planned number
    units:
        nl: "%s storypoints naast verwachting"
        en: "%s story points off expectation"
    measurement:
        unit: point
    preferred: false
    source:
        jira: null
    category: velocity
  - filename: 04-weighted-story-points.sql
    table: weighted_story_points
    column: num_weighted_points
    default: 0
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Gewogen storypoints
        en: Weighted story points
    long_descriptions:
        nl: Het aantal punten in de sprint wanneer deze genormaliseerd worden met een wisselkoers van alle projecten
        en: The number of points in the sprint after normalizing then using an exchange rate of all projects
    units:
        nl: "%s gewogen storypoints"
        en: "%s weighted story points"
    measurement:
        unit: point
    preferred: false
    source:
        jira: "${jira_url}/secure/BrowseProjects.jspa"
    category: velocity
  - filename: 04-attachments.sql
    table: attachments
    column: num_attachments
    default: 0
    combine: sum
    descriptions:
        nl: Bijlagen
        en: Attachments
    long_descriptions:
        nl: Het aantal bijlagen dat bij items in de sprint is toegevoegd
        en: The number of attachements that is added to items in the sprint
    units:
        nl: "%s bijlagen"
        en: "%s attachments"
    source:
        jira: "${jira_url}/secure/IssueNavigator.jspa?jqlQuery=${jira_project} and ${jira_sprint} and attachments is not empty&runQuery=true"
    category: tracking
  - filename: 04-labels.sql
    table: labels
    column: num_labels
    default: 0
    combine: sum
    descriptions:
        nl: Labels
        en: Labels
    long_descriptions:
        nl: Het aantal labels dat bij items in de sprint is toegevoegd
        en: The number of labels that is added to items in the sprint
    units:
        nl: "%s labels"
        en: "%s labels"
    source:
        jira: "${jira_url}/secure/IssueNavigator.jspa?jqlQuery=${jira_project} and ${jira_sprint} and labels is not empty&runQuery=true"
    category: tracking
  - filename: 04-impediments.sql
    table: impediments
    column: num_impediments
    default: 0
    combine: sum
    descriptions:
        nl: Impediments
        en: Impediments
    long_descriptions:
        nl: Het aantal items in de sprint dat gemarkeerd is als geblokeerd door een impediment of een andere taak buiten het team
        en: The number of items in the sprint that is marked as blocked due to an impediment or another external task
    units:
        nl: "%s impediments"
        en: "%s impediments"
    measurement:
        unit: issue
    source:
        jira: "${jira_url}/secure/IssueNavigator.jspa?jqlQuery=${jira_project} and ${jira_sprint} and Flagged %3D Impediment&runQuery=true"
    category: tracking
  - filename: 04-late-rank-changes.sql
    table: rank_changes
    column: num_late_rank_changes
    default: 0
    combine: sum
    descriptions:
        nl: Late rangwijzigingen
        en: Late rank changes
    long_descriptions:
        nl: Het aantal wijzigingen in volgorde op de backlog na het begin van de sprint
        en: The number of changes in the order on the backlog after the sprint start
    units:
        nl: "%s rangwijzigingen na begin van sprint"
        en: "%s rank changes after start of sprint"
    measurement:
        unit: change
    source:
        jira: null
    category: tracking
  - filename: 04-not-done-points.sql
    table: not_done
    column: num_not_done_points
    default: 0
    summarize:
        operation: sum
        field: story_points
        details: [key, story_points]
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Onvoltooide storypoints
        en: Unfinished story points
    long_descriptions:
        nl: Het totaal aantal storypoints dat nog niet tijdens de sprint zijn afgerond
        en: The total number of story points that are not yet done during the sprint
    units:
        nl: "%s storypoints die nog niet afgerond zijn"
        en: "%s story points that are not yet done"
    measurement:
        unit: point
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    category: velocity
  - filename: 04-late-story-points.sql
    table: late_story_points
    column: num_late_points
    default: 0
    summarize:
        operation: sum
        field: story_points
        details: [key, story_points]
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Late storypoints
        en: Late story points
    long_descriptions:
        nl: Het totaal aantal storypoints dat later dan 1 dag na het begin van de sprint toegevoegd worden
        en: The total number of story points that is added later than 1 day after the start of the sprint
    units:
        nl: "%s late storypoints"
        en: "%s late story points"
    measurement:
        unit: point
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    category: velocity
  - filename: 04-added-stories.sql
    table: added_stories
    column: num_added_stories
    default: 0
    summarize:
        operation: count_unique
        field: key
        details: [key]
    combine: sum
    descriptions:
        nl: Heringeplande stories
        en: Replanned stories
    long_descriptions:
        nl: Het totaal aantal stories dat uit een eerdere sprint wordt toegevoegd aan de sprint
        en: The total number of stories that is added from an earlier sprint to the sprint
    units:
        nl: "%s stories toegevoegd uit eerdere sprint"
        en: "%s stories added from earlier sprint"
    measurement:
        unit: point
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    category: tracking
  - filename: 04-added-story-points.sql
    table: added_story_points
    column: num_added_points
    default: 0
    summarize:
        operation: sum
        field: story_points
        details: [key, story_points]
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Heringeplande storypoints
        en: Replanned story points
    long_descriptions:
        nl: Het totaal aantal storypoints dat uit een eerdere sprint wordt toegevoegd aan de sprint
        en: The total number of story points that is added from an earlier sprint to the sprint
    units:
        nl: "%s storypoints toegevoegd uit eerdere sprint"
        en: "%s story points added from earlier sprint"
    measurement:
        unit: point
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    category: velocity
  - filename: 04-removed-stories.sql
    table: removed_stories
    column: num_removed_stories
    default: 0
    summarize:
        operation: count_unique
        field: key
        details: [key]
    combine: sum
    descriptions:
        nl: Doorgeschoven stories
        en: Removed stories
    long_descriptions:
        nl: Het totaal aantal stories dat tijdens de sprint wordt weggehaald of doorgeschoven
        en: The total number of stories that is (re)moved during the sprint
    units:
        nl: "%s doorgeschoven stories"
        en: "%s removed stories"
    measurement:
        unit: point
        superset: num_incomplete_points
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    category: tracking
  - filename: 04-removed-story-points.sql
    table: removed_story_points
    column: num_replaced_points
    patterns:
        issue_removed: ${s(issue_not_done)} AND new_issue.sprint_id IS NULL
    default: 0
    summarize:
        operation: sum
        field: story_points
        details: [key, story_points]
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Teruggehaalde storypoints
        en: Replaced story points
    long_descriptions:
        nl: Het totaal aantal storypoints dat tijdens de sprint wordt teruggezet op de product backlog
        en: The total number of story points that is placed back on the product backlog during the sprint
    units:
        nl: "%s terruggeplaatste storypoints"
        en: "%s replaced story points"
    measurement:
        unit: point
        superset: num_incomplete_points
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    category: velocity
  - filename: 04-removed-story-points.sql
    table: removed_story_points
    column: num_moved_points
    patterns:
        issue_removed: ${s(issue_not_done)} AND new_issue.sprint_id IS NOT NULL
    default: 0
    summarize:
        operation: sum
        field: story_points
        details: [key, story_points]
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Doorgeschoven storypoints
        en: Moved story points
    long_descriptions:
        nl: Het totaal aantal storypoints dat tijdens de sprint wordt doorgeschoven naar een volgende sprint
        en: The total number of story points that is moved to a later sprint during the sprint
    units:
        nl: "%s doorgeschoven storypoints"
        en: "%s moved story points"
    measurement:
        unit: point
        superset: num_incomplete_points
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    category: velocity
  - filename: 04-removed-story-points.sql
    table: removed_story_points
    column: num_removed_points
    patterns:
        issue_removed: ${s(issue_excluded, issue="new_issue")}
    default: 0
    summarize:
        operation: sum
        field: story_points
        details: [key, story_points]
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Weggehaalde storypoints
        en: Removed story points
    long_descriptions:
        nl: Het totaal aantal storypoints dat tijdens de sprint wordt weggehaald en afgesloten als onnodig
        en: The total number of story points that is removed and closed as unnecessary during the sprint
    units:
        nl: "%s weggehaalde storypoints"
        en: "%s removed story points"
    measurement:
        unit: point
        superset: num_incomplete_points
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    category: velocity
  - expression: 'num_not_done_points + num_replaced_points + num_moved_points + num_removed_points'
    column: num_incomplete_points
    default: 0
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Incomplete storypoints
        en: Incomplete story points
    long_descriptions:
        nl: Het totaal aantal storypoints dat niet afgerond is tijdens de sprint
        en: The total number of story points that is not completed during the sprint
    units:
        nl: "%s incomplete storypoints"
        en: "%s incomplete story points"
    measurement:
        unit: point
    preferred: true
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    category: velocity
  - filename: 04-stories.sql
    table: stories
    column: num_stories
    default: 0
    summarize:
        operation: count_unique
        field: key
        details: [key]
    combine: sum
    descriptions:
        nl: User stories
        en: User stories
    long_descriptions:
        nl: Het aantal stories in de sprint
        en: The number of stories in the sprint
    units:
        nl: "%s stories"
        en: "%s stories"
    measurement:
        unit: item
        superset: backlog_size
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    category: tracking
  - filename: 04-done-story-points.sql
    table: done_story_points
    column: num_done_stories
    patterns:
        story_point_types: NOT (${s(issue_bug)})
    default: 0
    summarize:
        operation: count_unique
        field: key
        details: [key]
    combine: sum
    descriptions:
        nl: Afgeronde stories
        en: Done stories
    long_descriptions:
        nl: Het aantal stories dat in de sprint wordt afgerond
        en: The number of stories that are completed in the sprint
    units:
        nl: "%s afgeronde stories"
        en: "%s done stories"
    measurement:
        unit: item
        superset: num_done_items
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    category: tracking
  - filename: 04-issue-links.sql
    table: issue_links
    column: num_links
    default: 0
    combine: sum
    descriptions:
        nl: Item-links
        en: Item links
    long_descriptions:
        nl: Het totaal aantal projectracker-links dat wordt gemaakt vanuit items in de sprint
        en: The total number of project tracker links that are made from items in the sprint
    units:
        nl: "%s item-links"
        en: "%s item links"
    source:
        jira: "${jira_url}/secure/IssueNavigator.jspa?jqlQuery=${jira_project} and ${jira_sprint} and issueFunction in hasLinks()&runQuery=true"
    category: tracking
  - filename: 05-number-of-comments.sql
    table: issue_comments
    column: num_comments
    default: 0
    combine: sum
    descriptions:
        nl: Commentaren
        en: Comments
    long_descriptions:
        nl: Het totaal aantal commentaren in de projecttracker bij items in de sprint
        en: The total number of comments in the project tracker for items in the sprint
    units:
        nl: "%s commentaren bij items"
        en: "%s item comments"
    source:
        jira: "${jira_url}/secure/IssueNavigator.jspa?jqlQuery=${jira_project} and ${jira_sprint} and issueFunction in hasComments()&runQuery=true"
    category: tracking
  - filename: 05-average-changes.sql
    table: issue_changes
    column: avg_changes
    default: 0
    combine: mean
    descriptions:
        nl: Wijzigingen per item
        en: Changes per item
    long_descriptions:
        nl: Het gemiddeld aantal wijzigingen in de projecttracker per item in de sprint
        en: The average number of changes in the project tracker for each item in the sprint
    units:
        nl: "gemiddeld %s wijzigingen per item"
        en: "average of %s changes per item"
    measurement:
        unit: [change, item]
        divisor: backlog_size
    source:
        jira: null
    category: tracking
  - filename: 05-issue-change-pivot.sql
    table: issue_change_pivot
    column: avg_change_day
    combine: mean
    descriptions:
        nl: Middelpunt van itemwijzigingen
        en: Midpoint of item changes
    long_descriptions:
        nl: De gemiddelde dag geteld vanaf het begin van de sprint waarop wijzigen aan items in de sprint worden gemaakt
        en: The average day counted from the start of the sprint when changes to items in the sprint are made
    values:
        type: duration
        intervals:
            - unit: days
              key: d
              num: 5
    units:
        nl: "middelpunt van itemwijzigingen op %s dagen na begin van sprint"
        en: "midpoint of item changes at %s days after start of sprint"
    measurement:
        unit: time
    source:
        jira: null
    category: tracking
  - expression: "done_story_points / sprint_weekdays"
    column: velocity
    default: 0
    combine: mean
    values:
        type: fraction
        denominator: 10
    descriptions:
        nl: Dagelijkse velocity
        en: Daily velocity
    long_descriptions:
        nl: Het aantal storypoints per werkdag dat in de sprint wordt gerealiseerd
        en: The number of story points per working day that are realized during the sprint
    units:
        nl: "%s storypoints per werkdag"
        en: "%s story points per working day"
    short_units:
        nl: "%s punten/dag"
        en: "%s points/day"
    measurement:
        unit: [point, time]
        dividend: done_story_points
        divisor: sprint_weekdays
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    category: velocity
  - expression: "pmax(0, rowSums(embed(done_story_points / num_done_stories, 3)) / 3)"
    column: done_points_per_story_three_average
    window:
        dimension: 3
        group: project_id
    default: 0
    combine: mean
    values:
        type: fraction
        denominator: 10
    descriptions:
        nl: Punten per afgemaakte story over drie sprints
        en: Points per done story over three sprints
    long_descriptions:
        nl: Het aantal storypoints per story gemiddeld wordt gerealiseerd over de afgelopen drie sprints
        en: The number of story points per story that are realized on average over the previous three sprints
    units:
        nl: "%s storypoints per story over 3 sprints"
        en: "%s story points per story over 3 sprints"
    short_units:
        nl: "%s punten/story"
        en: "%s points/story"
    measurement:
        unit: [point, [item, sprint]]
        dividend: done_story_points
        divisor: [num_done_stories]
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    preferred: false
    category: velocity
  - expression: "rowSums(embed(done_story_points, 3)) / 3"
    column: velocity_three
    window:
        dimension: 3
        group: project_id
    default: 0
    combine: mean
    values:
        type: fraction
        denominator: 10
    descriptions:
        nl: 3-sprint velocity
        en: Three-sprint velocity
    long_descriptions:
        nl: Het aantal storypoints per sprint gerealiseerd over de afgelopen drie sprints
        en: The number of story points per sprint that are realized during the past three sprints
    units:
        nl: "velocity van %s storypoints over drie sprints"
        en: "velocity of %s story points over three sprints"
    short_units:
        nl: "%s punten/sprint"
        en: "%s points/sprint"
    predictor:
        nl: Enkel velocity
        en: Only velocity
    measurement:
        unit: [point, sprint]
        dividend: done_story_points
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
    category: velocity
    preferred: true
  - expression: "rowSums(embed(done_story_points, 7)) / 7"
    column: velocity_seven
    window:
        dimension: 7
        group: project_id
    default: 0
    combine: mean
    values:
        type: fraction
        denominator: 10
    descriptions:
        nl: 7-sprint velocity
        en: Seven-sprint velocity
    long_descriptions:
        nl: Het aantal storypoints per sprint gerealiseerd over de afgelopen zeven sprints
        en: The number of story points per sprint that are realized during the past seven sprints
    units:
        nl: "velocity van %s storypoints over zeven sprints"
        en: "velocity of %s story points over seven sprints"
    short_units:
        nl: "%s punten/sprint"
        en: "%s points/sprint"
    measurement:
        unit: [point, sprint]
        dividend: done_story_points
    source:
        jira: null
    category: velocity
  - expression: "num_story_points - velocity_three"
    column: over_value
    default: 0
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Bovengeplande punten
        en: Overplanned points
    long_descriptions:
        nl: Het aantal storypoints dat meer gepland is voor de sprint dan de velocity van de afgelopen drie sprints
        en: The number of story points that are planned for the sprint over the velocity of the past three sprints
    units:
        nl: "%s storypoints boven velocity"
        en: "%s story points above velocity"
    short_units:
        nl: "%s extra points"
        en: "%s extra points"
    measurement:
        unit: point
        superset: num_story_points
    preferred: false
    source:
        jira: null
    category: velocity
  - filename: 06-other-issues-done.sql
    table: other_done_issues
    column: other_done_issues
    default: 0
    combine: sum
    descriptions:
        nl: Afgeronde niet-story items
        en: Done non-story items
    long_descriptions:
        nl: Het aantal items dat is afgerond in de sprint en geen story of subtask zijn
        en: The number of items that are completed during the sprint and are not a story or subtask
    units:
        nl: "%s afgeronde items die geen story of subtask zijn"
        en: "%s done items that are not stories or subtasks"
    measurement:
        unit: item
        superset: num_done_items
    source:
        jira: "${jira_url}/secure/IssueNavigator.jspa?jqlQuery=${jira_project} and ${jira_sprint} and ${q(issue_other)} and resolution < %22${sprint_end_date}%22&runQuery=true"
    category: tracking
  - expression: 'num_done_stories + other_done_issues'
    column: num_done_items
    default: 0
    combine: sum
    descriptions:
        nl: Gerealiseerde items
        en: Done items
    long_descriptions:
        nl: Het aantal items dat in de sprint wordt afgerond
        en: The number of items that are completed in the sprint
    measurement:
        unit: item
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=reporting&chart=sprintRetrospective&sprint=${jira_sprint_id}"
        jira_version: "${jira_url}/projects/${jira_key}/versions/${jira_sprint_id}"
    category: tracking
  - filename: 07-concurrent-in-progress-stories.sql
    table: concurrent_in_progress_stories
    column: avg_concurrent_progress
    default: 0
    summarize:
        operation: mean
        field: num
        details: [key, story_points, num]
    combine: mean
    descriptions:
        nl: Gelijktijdige stories in progress
        en: Concurrent stories in progress
    long_descriptions:
        nl: Het gemiddelde aantal stories dat gelijktijdig in progress is tijdens de sprint
        en: The average number of stories that are in progress at the same time during the sprint
    units:
        nl: "gemiddeld %s stories die gelijktijdig in progress zijn"
        en: "average of %s stories that are concurrently in progress"
    measurement:
        unit: item
    source:
        jira: null
    category: tracking
  - filename: 07-duration-in-progress-stories.sql
    table: duration_in_progress_stories
    column: avg_duration_progress
    default: 0
    summarize:
        operation: mean
        field: num
        details: [key, story_points, num]
    combine: mean
    descriptions:
        nl: Looptijd stories in progress
        en: Duration of stories in progress
    units:
        nl: "gemiddeld %s dagen in progress per story"
        en: "average of %s days in progress per story"
    long_descriptions:
        nl: Het gemiddelde aantal dagen dat een story in progress is tijdens de sprint
        en: The average number of days that a story is in progress during the sprint
    short_units:
        nl: "%s dagen/story"
        en: "%s days/story"
    measurement:
        unit: [time, item]
        divisor: num_stories
    source:
        jira: null
    category: tracking
  - filename: 08-vcs-statistics.sql
    table: vcs_statistics
    column: [num_commits, avg_insertions, avg_deletions, avg_size, avg_files, avg_lines]
    combine: [sum, mean, mean, mean, mean, mean]
    default: 0
    descriptions:
        nl:
            - Commits
            - Toegevoegde regels
            - Verwijderde regels
            - Commitgrootte
            - Bestanden in commit
            - Regels in commit
        en:
            - Commits
            - Added lines
            - Removed lines
            - Commit size
            - Files in commit
            - Lines in commit
    long_descriptions:
        nl:
            - Het aantal commits dat in het versiebeheersysteem wordt gemaakt tijdens de sprint
            - Het gemiddelde aantal regels dat in een commit in het versiebeheersysteem wordt toegevoegd tijdens de sprint
            - Het gemiddelde aantal regels dat in een commit in het versiebeheersysteem wordt weggehaald tijdens de sprint
            - De gemiddelde grootte van een commit dat in het versiebeheersystem wordt gemaakt tijdens de sprint in bytes (in Git wordt alleen metadata gerekend)
            - Het gemiddelde aantal bestanden dat in een commit in het versiebeheersysteem wordt aangepast tijdens de sprint
            - Het gemiddelde aantal regels dat in een commit in het versiebeheersysteem wordt aangepast tijdens de sprint
        en:
            - The number of commits that are made in the version control system during the sprint
            - The average number of lines that are added in a commit in the version control system during the sprint
            - The average number of lines that are removed in a commit in the version control system during the sprint
            - The average size in bytes of a commit that is made in the version control system during the sprint (only metadata is counted in Git)
            - The average number of files that are changed in a commit in the version control system during the sprint
            - The average number of lines that are changed in a commit in the version control system during the sprint
    units:
        nl:
            - "%s commits"
            - "gemiddeld %s toegevoegde regels per commit"
            - "gemiddeld %s verwijderde regels per commit"
            - "gemiddeld %s bytes per commit"
            - "gemiddeld %s bestanden per commit"
            - "gemiddeld %s regels per commit"
        en:
            - "%s commits"
            - "average of %s added lines per commit"
            - "average of %s removed lines per commit"
            - "average of %s bytes per commit"
            - "average of %s files per commit"
            - "average of %s lines per commit"
    short_units:
        nl:
            - "%s"
            - "%s regels/commit"
            - "%s regels/commit"
            - "%s bytes/commit"
            - "%s bestanden/commit"
            - "%s regels/commit"
        en:
            - "%s"
            - "%s lines/commit"
            - "%s lines/commit"
            - "%s bytes/commit"
            - "%s files/commit"
            - "%s lines/commit"
    measurement:
        - unit: commit
        - unit: [line, commit]
          divisor: num_commits
        - unit: [line, commit]
          divisor: num_commits
        - unit: [byte, commit]
          divisor: num_commits
        - unit: [file, commit]
          divisor: num_commits
        - unit: [line, commit]
          divisor: num_commits
    category: code
  - filename: 09-metric-count.sql
    table: metric_count
    column: num_metrics
    combine: max
    descriptions:
        nl: Metrieken
        en: Metrics
    long_descriptions:
        nl: Het aantal metrieken dat wordt gemeten door het kwaliteitssysteem tijdens de sprint
        en: The number of metrics that are measured by the quality system during the sprint
    units:
        nl: "%s metrieken"
        en: "%s metrics"
    measurement:
        unit: metric
    source:
        quality: "${quality_url}/${quality_name}"
        metric_history: "${metric_history_url}/${metric_history_file}"
    cache: true
    category: metrics
  - filename: 09-red-metric-count.sql
    table: red_metric_count
    column: num_red_metrics
    combine: max
    descriptions:
        nl: Rode metrieken
        en: Red metrics
    long_descriptions:
        nl: Het aantal metrieken dat een rode meting hebben in het kwaliteitssysteem tijdens de sprint
        en: The number of metrics that have a red measurement in the quality system during the sprint
    units:
        nl: "%s metrieken die op rood staan"
        en: "%s metrics that are red"
    measurement:
        unit: metric
        superset: num_metrics
    source:
        quality: "${quality_url}/${quality_name}"
        metric_history: "${metric_history_url}/${metric_history_file}"
    cache: true
    category: metrics
  - filename: 09-missing-metric-count.sql
    table: missing_metric_count
    column: num_missing_metrics
    combine: max
    descriptions:
        nl: Metrieken zonder bronn
        en: Metrics without source
    long_descriptions:
        nl: Het aantal metrieken die een missende bron hebben in het kwaliteitssysteem tijdens de sprint
        en: The number of metrics that are missing a source in the quality system during the sprint
    units:
        nl: "%s metrieken met missende bron"
        en: "%s metrics with missing sources"
    measurement:
        unit: metric
        superset: num_metrics
    preferred: false
    source:
        quality: "${quality_url}/${quality_name}"
        metric_history: "${metric_history_url}/${metric_history_file}"
    cache: true
    category: metrics
  - filename: 10-metric-target-change.sql
    table: metric_target_change
    column: num_metric_target_changes
    default: 0
    combine: sum
    descriptions:
        nl: Veranderde metrieknormen
        en: Changed metric targets
    long_descriptions:
        nl: Het aantal normen van metrieken van het kwaliteitssysteem dat is aangepast tijdens de sprint
        en: The number of targets of metrics in the quality system that are adjusted during the sprint
    units:
        nl: "%s veranderingen aan metrieknormen"
        en: "%s changes to metric targets"
    measurement:
        unit: change
    preferred: false
    source:
        metric_options: "${metric_options_url}/blob/master/${metric_options_file}"
        quality: "${quality_url}/${quality_name}"
    cache: true
    category: metrics
  - filename: 11-early-rank-changes.sql
    table: early_rank_changes
    column: num_early_rank_changes
    default: 0
    combine: sum
    descriptions:
        nl: Tijdige rangwijzigingen
        en: Timely rank changes
    long_descriptions:
        nl: Het aantal wijzigingen aan de volgorde op de backlog voor het begin van de sprint
        en: The number of changes to the order of the backlog before the start of the sprint
    units:
        nl: "%s rangwijzigingen voor begin van sprint"
        en: "%s rank changes before start of sprint"
    measurement:
        unit: change
        superset: num_early_changes
    source:
        jira: null
    category: tracking
  - filename: 11-early-storypoint-changes.sql
    table: early_storypoint_changes
    column: num_early_storypoint_changes
    default: 0
    combine: sum
    descriptions:
        nl: Tijdige storypointwijzigingen
        en: Timely story point changes
    long_descriptions:
        nl: Het aantal wijzigingen aan storypoints voor het begin van de sprint
        en: The number of changes to story points before the start of the sprint
    units:
        nl: "%s wijzigingen aan storypoints voor begin van sprint"
        en: "%s story point changes before start of sprint"
    measurement:
        unit: change
        superset: num_early_changes
    source:
        jira: null
    category: tracking
  - filename: 11-early-changes.sql
    table: early_changes
    column: num_early_changes
    default: 0
    combine: sum
    descriptions:
        nl: Vroege itemwijzigingen
        en: Early item changes
    long_descriptions:
        nl: Het aantal wijzigingen aan items in de projecttracker voor het begin van de sprint
        en: The number of changes to items in the project tracker before the start of the sprint
    units:
        nl: "%s overige wijzigingen aan issues voor begin van sprint"
        en: "%s other issue changes before start of sprint"
    measurement:
        unit: change
    source:
        jira: null
    category: tracking
  - filename: 11-backlog-sprint.sql
    table: backlog_sprint
    column: backlog_size
    default: 0
    combine: max
    descriptions:
        nl: Items op sprintbacklog
        en: Items on sprint backlog
    long_descriptions:
        nl: Het aantal items in de projecttracker op de sprintbacklog
        en: The number of items in the project tracker on the sprint backlog
    units:
        nl: "%s items voor de sprint op de backlog"
        en: "%s items for the sprint on the backlog"
    measurement:
        unit: item
    source:
        jira: null
    category: backlog
  - filename: 11-backlog-ready-status.sql
    table: backlog_ready_status
    column: backlog_ready_status
    default: 0
    combine: max
    descriptions:
        nl: Items met readystatus op sprintbacklog
        en: Items with ready status on sprint backlog
    long_descriptions:
        nl: Het aantal items in de projecttracker met een readystatus op de sprintbacklog
        en: The number of items in the project tracker with a ready status on the sprint backlog
    units:
        nl: "%s items met readystatus voor de sprint op de backlog"
        en: "%s items with ready status for the sprint on the backlog"
    measurement:
        unit: item
        superset: backlog_size
    source:
        jira: null
    category: backlog
  - filename: 11-backlog-all.sql
    table: backlog_stories
    column: backlog_points_per_story
    default: 0
    patterns:
        issue_backlog: ${s(issue_story)} AND ${t("issue")}.story_points IS NOT NULL
    summarize:
        operation: mean
        field: story_points
        details: [key, story_points]
    combine:
        project: sum
        sprint: max
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Punten per story op backlog
        en: Points per story on backlog
    long_descriptions:
        nl: Het aantal storypoints dat iedere story gemiddeld heeft op de gehele backlog in de projecttracker bij het einde van de sprint
        en: The average number of story points for each story on the whole backlog in the project tracker at the end of the sprint
    units:
        nl: "%s punten per story op de gehele backlog"
        en: "%s points per story on the whole backlog"
    short_units:
        nl: "%s punten/story"
        en: "%s points/story"
    measurement:
        unit: [point, item]
        dividend: backlog_story_points
        divisor: backlog_items
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    cache: true
    category: backlog
  - expression: "cumsum(backlog_points_per_story) / sprint_num"
    column: backlog_story_points_all_average
    window:
        dimension: 1
        group: project_id
    default: 0
    combine: mean
    values:
        type: fraction
        denominator: 10
    descriptions:
        nl: Points per story op backlog over alle sprints
        en: Points per story on backlog over all sprints
    long_descriptions:
        nl: Het aantal storypoints dat iedere story gemiddeld heeft op de gehele backlog in de projecttracker over alle eerdere sprints heen
        en: The average number of story points for each story on the whole backlog in the project tracker over all earlier sprints
    units:
        nl: "%s punten per story op de gehele backlog over alle sprints"
        en: "%s points per story on the whole backlog over all sprints"
    short_units:
        nl: "%s punten/story"
        en: "%s points/story"
    measurement:
        unit: [point, [item, sprint]]
        dividend: backlog_story_points
        divisor: [backlog_items, sprint_num]
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - expression: "pmax(0, rowSums(embed(backlog_points_per_story, 3)) / 3)"
    column: backlog_story_points_three_average
    precompute: True
    window:
        dimension: 3
        group: project_id
    default: 0
    combine: mean
    values:
        type: fraction
        denominator: 10
    descriptions:
        nl: Points per story op backlog over drie sprints
        en: Points per story on backlog over three sprints
    long_descriptions:
        nl: Het aantal storypoints dat iedere story gemiddeld heeft op de gehele backlog in de projecttracker over de afgelopen drie sprints
        en: The average number of story points for each story on the whole backlog in the project tracker over the previous three sprints
    units:
        nl: "%s punten per story op de gehele backlog over 3 sprints"
        en: "%s points per story on the whole backlog over 3 sprints"
    short_units:
        nl: "%s punten/story"
        en: "%s points/story"
    measurement:
        unit: [point, [item, sprint]]
        dividend: backlog_story_points
        divisor: [backlog_items]
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - filename: 11-backlog-all.sql
    table: backlog_all
    column: backlog_items
    default: 0
    patterns:
        issue_backlog:
            jira: ${t("issue")}."type" NOT IN (5, 6, 9, 10, 12, 20, 22, 10301)
            jira_component_version: ${t("issue")}."type" NOT IN (5, 6)
            tfs: ${t("issue")}."type" NOT IN ('Task', 'Test Case', 'Test Suite', 'Test Plan', 'Use Case')
    summarize:
        operation: count
        with_missing: true
        field: story_points
        details: [key, story_points]
    combine:
        project: sum
        sprint: max
    descriptions:
        nl: Items op backlog
        en: Items on backlog
    long_descriptions:
        nl: Het aantal items in de projecttracker dat op de gehele backlog staat bij het einde van de sprint
        en: The number of items in the project tracker that is on the whole backlog at the end of the sprint
    units:
        nl: "%s items op de gehele backlog"
        en: "%s items on the whole backlog"
    measurement:
        unit: item
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    cache: true
    category: backlog
  - filename: 11-backlog-all.sql
    table: backlog_stories
    column: backlog_removed_story_points
    default: 0
    patterns:
        issue_backlog: ${s(issue_story)} AND ${s(issue_excluded)} AND ${t("issue")}.sprint_id IS NULL AND ${t("issue")}.updated >= ${s(sprint_open, sprint="interval_sprint")}
    summarize:
        operation: sum
        field: story_points
        details: [key, story_points, fixversion]
    combine:
        project: sum
        sprint: max
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Verwijderde storypoints van backlog
        en: Removed story points from backlog
    long_descriptions:
        nl: Het totaal aantal storypoints dat is verwijderd van de gehele backlog in de projecttracker tijdens de sprint
        en: The number of story points that is removed from the whole backlog in the project tracker during the sprint
    units:
        nl: "%s verwijderde storypoints van de gehele backlog"
        en: "%s removed story points from the whole backlog"
    short_units:
        nl: "%s verwijderde storypoints"
        en: "%s removed story points"
    measurement:
        unit: point
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - filename: 11-backlog-all.sql
    table: backlog_stories
    column: backlog_estimated_removed_story_points
    default: 0
    patterns:
        issue_backlog: ${s(issue_story)} AND ${s(issue_excluded)} AND ${t("issue")}.sprint_id IS NULL AND ${t("issue")}.updated >= ${s(sprint_open, sprint="interval_sprint")}
    summarize:
        operation: sum_of_na_avg
        field: story_points
        reference: backlog_story_points
        details: [key]
        filter: 'is.na(story_points)'
    combine:
        project: sum
        sprint: max
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Verwijderde ongepokerde storypoints van backlog
        en: Removed non-pokered story points from backlog
    long_descriptions:
        nl: Een automatische schatting van het aantal ongepokerde storypoints dat is verwijderd van de gehele backlog in de projecttracker tijdens de sprint
        en: An automated estimate of the number of story points that are not pokered and are removed from the whole backlog in the project tracker at the start of the sprint
    units:
        nl: "%s geschatte verwijderde storypoints van de gehele backlog"
        en: "%s estimated removed story points from the whole backlog"
    short_units:
        nl: "%s geschatte verwijderde points"
        en: "%s estimated removed points"
    measurement:
        unit: point
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - filename: 11-backlog-all.sql
    table: backlog_stories
    column: backlog_removed_stories
    default: 0
    patterns:
        issue_backlog: ${s(issue_story)} AND ${s(issue_excluded)} AND newer_issue.sprint_id IS NULL AND ${t("issue")}.updated >= ${s(sprint_open, sprint="interval_sprint")}
    summarize:
        operation: count 
        with_missing: true
        field: story_points
        details: [key, story_points]
    combine:
        project: sum
        sprint: max
    descriptions:
        nl: Verwijderde stories van backlog
        en: Removed stories from backlog
    long_descriptions:
        nl: Het totaal aantal stories dat is verwijderd van de gehele backlog in de projecttracker tijdens de sprint
        en: The number of stories that is removed from the whole backlog in the project tracker during the sprint
    units:
        nl: "%s verwijderde stories van de gehele backlog"
        en: "%s removed stories from the whole backlog"
    short_units:
        nl: "%s verwijderde stories"
        en: "%s removed stories"
    measurement:
        unit: item
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - filename: 11-backlog-added.sql
    table: backlog_stories
    column: backlog_added_story_points
    default: 0
    patterns:
        issue_backlog: ${s(issue_story)}
    summarize:
        operation: sum
        field: story_points
        details: [key, story_points, fixversion]
        overlap: [backlog_removed_story_points, done_story_points]
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Toegevoegde storypoints aan backlog
        en: Added story points on backlog
    long_descriptions:
        nl: Het totaal aantal storypoints dat is toegevoegd aan de gehele backlog in de projecttracker tijdens de sprint
        en: The number of story points that is added to the whole backlog in the project tracker during the sprint
    units:
        nl: "%s toegevoegde storypoints aan de gehele backlog"
        en: "%s aaded story points on the whole backlog"
    short_units:
        nl: "%s toegevoegde storypoints"
        en: "%s added story points"
    measurement:
        unit: point
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - filename: 11-backlog-added.sql
    table: backlog_stories
    column: backlog_estimated_added_story_points
    default: 0
    patterns:
        issue_backlog: ${s(issue_story)}
    summarize:
        operation: sum_of_na_avg
        field: story_points
        reference: backlog_story_points
        details: [key]
        filter: 'is.na(story_points)'
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Toegevoegde ongepokerde storypoints aan backlog
        en: Added non-pokered story points on backlog
    long_descriptions:
        nl: Een automatische schatting van het aantal ongepokerde storypoints dat is toegevoegd aan de gehele backlog in de projecttracker tijdens de sprint
        en: An automated estimate of the number of story points that are not pokered and are added to the whole backlog in the project tracker at the start of the sprint
    units:
        nl: "%s geschatte toegevoegde storypoints aan de gehele backlog"
        en: "%s estimated added story points on the whole backlog"
    short_units:
        nl: "%s geschatte toegevoegde points"
        en: "%s estimated added points"
    measurement:
        unit: point
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - filename: 11-backlog-added.sql
    table: backlog_stories
    column: backlog_added_stories
    default: 0
    patterns:
        issue_backlog: ${s(issue_story)}
    summarize:
        operation: count
        with_missing: true
        field: story_points
        details: [key, story_points]
    combine: sum
    descriptions:
        nl: Toegevoegde stories aan backlog
        en: Added stories on backlog
    long_descriptions:
        nl: Het totaal aantal stories dat is toegevoegd aan de gehele backlog in de projecttracker tijdens de sprint
        en: The number of stories that is added to the whole backlog in the project tracker during the sprint
    units:
        nl: "%s toegevoegde stories aan de gehele backlog"
        en: "%s added stories on the whole backlog"
    short_units:
        nl: "%s toegevoegde stories"
        en: "%s added stories"
    measurement:
        unit: point
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - filename: 11-backlog-modified.sql
    table: backlog_stories
    column: backlog_modified_story_points
    default: 0
    patterns:
        issue_backlog: ${s(issue_story)}
    summarize:
        operation: sum
        field: story_points
        details: [key, story_points, fixversion]
        overlap: [backlog_removed_story_points, done_story_points]
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Aangepaste storypoints aan backlog
        en: Modified story points on backlog
    long_descriptions:
        nl: Het verschil in storypoints dat is aangepast op de gehele backlog in de projecttracker tijdens de sprint
        en: The difference in story points that is modified on the whole backlog in the project tracker during the sprint
    units:
        nl: "%s aangepaste storypoints aan de gehele backlog"
        en: "%s modified story points on the whole backlog"
    short_units:
        nl: "%s storypoints verschil"
        en: "%s story points difference"
    measurement:
        unit: point
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - filename: 11-backlog-modified.sql
    table: backlog_stories
    column: backlog_modified_points_three_average
    default: 0
    patterns:
        issue_backlog: ${s(issue_story)}
    summarize:
        operation: sum_of_na_diff
        field: [story_points, old_story_points, new_story_points]
        details: [key, old_story_points, new_story_points, fixversion]
        overlap: [backlog_removed_story_points, done_story_points]
        reference: backlog_story_points_three_average
        expression: true
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Aangepaste storypoints aan backlog ten opzichte van schatting
        en: Modified story points on backlog compared to estimation
    long_descriptions:
        nl: Het verschil in storypoints dat is aangepast op de gehele backlog in de projecttracker tijdens de sprint ten opzichte van het gemiddelde storypoints
        en: The difference in story points that is modified on the whole backlog in the project tracker during the sprint compared to average story points
    units:
        nl: "%s aangepaste storypoints aan de gehele backlog"
        en: "%s modified story points on the whole backlog"
    short_units:
        nl: "%s storypoints verschil"
        en: "%s story points difference"
    measurement:
        unit: point
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - filename: 11-backlog-all.sql
    table: backlog_stories
    column: backlog_story_points
    default: 0
    patterns:
        issue_backlog: ${s(issue_story)} AND ${t("issue")}.story_points IS NOT NULL
    summarize:
        operation: sum
        field: story_points
        details: [key, story_points, fixversion]
        overlap: [backlog_removed_story_points, done_story_points, backlog_added_story_points, backlog_modified_story_points]
    combine:
        project: sum
        sprint: max
    #prediction:
    #   - monte_carlo:
    #       name: backlog_burndown
    #       factors:
    #           - column: done_story_points
    #             scalar: -1
    #             prob: gamma
    #             params: [1, 0.5]
    #             #prob: triangle
    #             #params: [min(done_story_points), max(done_story_points), binmode(done_story_points)]
    #             sample: True
    #           - column: backlog_removed_stories
    #             name: backlog_removed_story_points
    #             multiplier: backlog_story_points_three_average
    #             scalar: -1
    #             prob: gamma
    #             params: [1, 0.5]
    #             #prob: triangle
    #             #params: [min(backlog_removed_stories), max(backlog_removed_stories), binmode(backlog_removed_stories)]
    #             sample: True
    #           - column: backlog_added_stories
    #             name: backlog_added_story_points
    #             multiplier: backlog_story_points_three_average
    #             scalar: 0.1
    #             prob: gamma
    #             params: [1, 0.5]
    #             #prob: triangle
    #             #params: [min(backlog_added_stories), max(backlog_added_stories), binmode(backlog_added_stories)]
    #             sample: True
    #           - column: backlog_modified_story_points
    #             scalar: 0.05
    #             prob: gamma
    #             params: [1, 0.5]
    #             #prob: triangle
    #             #params: [min(backlog_modified_story_points), max(backlog_modified_story_points), binmode(backlog_modified_story_points)]
    #             sample: True
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Storypoints op backlog
        en: Story points on backlog
    long_descriptions:
        nl: Het totaal aantal storypoints op de gehele backlog in de projecttracker bij het einde van de sprint
        en: The number of story points on the whole backlog in the project tracker at the end of the sprint
    units:
        nl: "%s storypoints op de gehele backlog"
        en: "%s story points on the whole backlog"
    short_units:
        nl: "%s"
        en: "%s"
    measurement:
        unit: point
        superset: backlog_points
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    cache: true
    category: backlog
  - filename: 11-backlog-all.sql
    table: backlog_stories
    column: backlog_expected_story_points
    default: 0
    patterns:
        issue_backlog: ${s(issue_story)}
    summarize:
        operation: sum_of_na_avg
        reference: backlog_story_points_three_average
        expression: True
        field: story_points
        details: [key]
        filter: 'is.na(story_points)'
    combine:
        project: sum
        sprint: max
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Ongepokerde storypoints op backlog
        en: Non-pokered story points on backlog
    long_descriptions:
        nl: Een automatische schatting van het aantal ongepokerde storypoints op de gehele backlog in de projecttracker bij het einde van de sprint
        en: An automated estimate of the number of story points that are not pokered on the whole backlog in the project tracker at the end of the sprint
    units:
        nl: "%s geschatte extra storypoints op de gehele backlog"
        en: "%s estimated additional story points on the whole backlog"
    short_units:
        nl: "%s geschatte points"
        en: "%s estimated points"
    measurement:
        unit: point
        superset: backlog_points
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    cache: true
    category: backlog
  - filename: 11-backlog-epic.sql
    table: backlog_epics
    column: backlog_epic_points
    default: 0
    summarize:
        operation: sum
        field: story_points
        details: [key, epic_children]
    combine:
        project: sum
        sprint: max
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Epicpoints op backlog
        en: Epic points on backlog
    long_descriptions:
        nl: Het totaal aantal storypoints dat bij epics hoort op de gehele backlog in de projecttracker bij het einde van de sprint
        en: The number of story points belonging to epics on the whole backlog in the project tracker at the end of the sprint
    units:
        nl: "%s epicpoints op de gehele backlog"
        en: "%s epic points on the whole backlog"
    short_units:
        nl: "%s epicpoints"
        en: "%s epic points"
    measurement:
        unit: point
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    cache: true
    category: backlog
  - expression: 'backlog_story_points + backlog_expected_story_points'
    column: backlog_points
    combine: sum
    prediction:
        - reference: velocity_three
        - reference: backlog_all_velocity_three
        - monte_carlo:
            name: velocity_three
            factors:
                - column: num_done_stories
                  multiplier: done_points_per_story_three_average
                  scalar: -1
                  prob: gamma
                  params: [1, 0.5]
                  #prob: triangle
                  #params: [min(num_done_stories), max(num_done_stories), binmode(num_done_stories)]
                  sample: True
        - monte_carlo:
            name: backlog_all_velocity_three
            factors:
                - column: backlog_all_velocity_three
                  scalar: 1
                  prob: gamma
                  params: [1, 0.5]
                  sample: true
        - monte_carlo:
            name: backlog_all_velocity_three_sep
            factors:
                - column: num_done_stories
                  multiplier: done_points_per_story_three_average
                  scalar: -1
                  prob: gamma
                  params: [1, 0.5]
                  #prob: triangle
                  #params: [min(num_done_stories), max(num_done_stories), binmode(num_done_stories)]
                  sample: True
                - column: backlog_removed_stories
                  multiplier: backlog_story_points_three_average
                  scalar: -1
                  prob: gamma
                  params: [1, 0.5]
                  #prob: triangle
                  #params: [min(backlog_removed_stories), max(backlog_removed_stories), binmode(backlog_removed_stories)]
                  sample: True
                - column: backlog_added_stories
                  multiplier: backlog_story_points_three_average
                  scalar: 1
                  prob: gamma
                  params: [1, 0.5]
                  #prob: triangle
                  #params: [min(backlog_added_stories), max(backlog_added_stories), binmode(backlog_added_stories)]
                  sample: True
                - column: backlog_modified_points_three_average
                  scalar: 0.5
                  prob: gamma
                  params: [1, 0.5]
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Volledige backloginschatting
        en: Total backlog estimation
    long_descriptions:
        nl: Het totaal aantal storypoints dat op de gehele backlog in de projecttracker staat bij het begin van de sprint, inclusief inschattingen van ongepokerde stories
        en: The total number of story points on the whole backlog in the project tracker at the start of the sprint, including estimates of non-pokered stories
    measurement:
        unit: point
    units:
        nl: "%s punten op de gehele backlog"
        en: "%s points on the whole backlog"
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - expression: 'backlog_removed_story_points + backlog_estimated_removed_story_points + done_story_points'
    column: backlog_dismiss_velocity
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Afgevoerde storypoints per sprint
        en: Dismissed story points per sprint
    long_descriptions:
        nl: Het aantal storypoints dat afgevoerd wordt van de gehele backlog tijdens de sprint
        en: The total number of story points that is dismissed from the whole backlog during the sprint
    units:
        nl: "%s afgevoerde punten van de gehele backlog"
        en: "%s dismissed points from the whole backlog"
    measurement:
        unit: point
    preferred: true
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - expression: "rowSums(embed(backlog_dismiss_velocity, 3)) / 3"
    column: backlog_dismiss_velocity_three
    window:
        dimension: 3
        group: project_id
    default: 0
    combine: mean
    values:
        type: fraction
        denominator: 10
    descriptions:
        nl: Afgevoerde storypoints over laatste 3 sprints
        en: Dismissed story points over latest three sprints
    long_descriptions:
        nl: Het aantal storypoints dat afgevoerd wordt per sprint van de gehele backlog over de afgelopen drie sprints
        en: The number of story points per sprint that is dismissed from the whole backlog during the past three sprints
    units:
        nl: "velocity van %s afgevoerde storypoints van de gehele backlog over drie sprints"
        en: "velocity of %s dismissed story points from the whole backlog over three sprints"
    short_units:
        nl: "%s afgevoerde punten/sprint"
        en: "%s dismissed points/sprint"
    predictor:
        nl: Met afvoeren
        en: With dismissal
    measurement:
        unit: [point, sprint]
        dividend: backlog_dismiss_velocity
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - expression: "done_story_points - backlog_added_story_points"
    column: backlog_adjustment
    combine: sum
    values:
        type: fraction
        denominator: 4
    descriptions:
        nl: Toegevoegde storypoints per sprint
        en: Added story points per sprint
    long_descriptions:
        nl: Het aantal storypoints dat toegevoegd wordt aan de gehele backlog tijdens de sprint
        en: The number of story points that is added to the whole backlog during the sprint
    units:
        nl: "%s toegevoegde storypoints aan de gehele backlog"
        en: "%s added story points on the whole backlog"
    short_units:
        nl: "%s toegevoegde punten"
        en: "%s added points"
    measurement:
        unit: point
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - expression: "pmax(0, rowSums(embed(backlog_adjustment, 3)) / 3)"
    column: backlog_adjustment_velocity_three
    window:
        dimension: 3
        group: project_id
    default: 0
    combine: mean
    values:
        type: fraction
        denominator: 10
    descriptions:
        nl: Toegevoegde storypoints over laatste 3 sprints
        en: Added story points over latest three sprints
    long_descriptions:
        nl: Het aantal storypoints dat toegevoegd wordt per sprint aan de gehele backlog over de afgelopen drie sprints
        en: The number of story points per sprint that is added to the whole backlog during the past three sprints
    units:
        nl: "velocity van %s toegevoegde storypoints aan de gehele backlog over drie sprints"
        en: "velocity of %s added story points on the whole backlog over three sprints"
    short_units:
        nl: "%s toegevoegde punten/sprint"
        en: "%s added points/sprint"
    predictor:
        nl: Met toevoeging
        en: With additions
    measurement:
        unit: [point, sprint]
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog
  - expression: "pmax(0, rowSums(embed(backlog_removed_story_points + backlog_estimated_removed_story_points + done_story_points - backlog_added_story_points + backlog_modified_points_three_average, 3)) / 3)"
    column: backlog_all_velocity_three
    window:
        dimension: 3
        group: project_id
    default: 0
    combine: mean
    values:
        type: fraction
        denominator: 10
    descriptions:
        nl: Veranderde storypoints over laatste 3 sprints
        en: Adjusted story points over latest three sprints
    long_descriptions:
        nl: Het aantal storypoints dat toegevoegd en verwijderd wordt per sprint aan de gehele backlog over de afgelopen drie sprints
        en: The number of story points per sprint that is added and removed to the whole backlog during the past three sprints
    units:
        nl: "velocity van %s storypoints veranderd op de gehele backlog over drie sprints"
        en: "velocity of %s story points adjusted on the whole backlog over three sprints"
    short_units:
        nl: "%s veranderde punten/sprint"
        en: "%s adjusted points/sprint"
    predictor:
        nl: Alle veranderingen
        en: All adjustments
    measurement:
        unit: [point, sprint]
    preferred: false
    source:
        jira: "${jira_url}/secure/RapidBoard.jspa?rapidView=${jira_board_id}&projectKey=${jira_key}&view=planning"
    category: backlog