# Pull Request ## Description Metrics relating to Pull Requests imported from a code repository tool (e.g. GitHub, GitLab). ## Measures | Name | Title | Description | | -------------------------------------------------- | ---------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------ | | `PullRequestDetail.elapseTime` | Elapse Time | The time from the first commit or the start of pull requests to its closure or merge, in hours. | | `PullRequestDetail.totalCycleTime` | Total Cycle Time | The total time from first commit to merge or closure pull requests, in hours. | | `PullRequestDetail.avgCycleTime` | Avg Cycle Time | Average time from first commit to merge or closure of pull requests, in hours. | | `PullRequestDetail.medianCycleTime` | Median Cycle Time | The median time from first commit to merge or closure of pull requests, in hours. | | `PullRequestDetail.p90CycleTime` | P90 Cycle Time | The 90th percentile time from first commit to merge or closure of pull requests, in hours. | | `PullRequestDetail.minCycleTime` | Min Cycle Time | The quickest time from first commit to merge or closure of pull requests, in hours. | | `PullRequestDetail.maxCycleTime` | Max Cycle Time | The slowest time from first commit to merge or closure of pull requests, in hours. | | `PullRequestDetail.totalDevelopmentTime` | Total Development Time | The total time from the first commit to opening the PR, in hours. | | `PullRequestDetail.avgDevelopmentTime` | Avg Development Time | The average time from the first commit to opening the PR, in hours. | | `PullRequestDetail.medianDevelopmentTime` | Median Development Time | The median time from the first commit to opening the PR, in hours. | | `PullRequestDetail.p90DevelopmentTime` | P90 Development Time | The 90th percentile time from the first commit to opening the PR, in hours. | | `PullRequestDetail.minDevelopmentTime` | Min Development Time | The earliest time from the first commit to opening the PR, in hours. | | `PullRequestDetail.maxDevelopmentTime` | Max Development Time | The slowest time from the first commit to opening the PR, in hours. | | `PullRequestDetail.minFirstCommittedAt` | Min First Committed at | Earliest UNIX timestamp for the first commit. | | `PullRequestDetail.minReviewRequestedAt` | Min Review Requested at | Earliest UNIX timestamp for the review request. | | `PullRequestDetail.totalResponseTime` | Total Response Time | Total time from PR opening to the first code review, in hours. | | `PullRequestDetail.avgResponseTime` | Avg Response Time | Average time from PR opening to the first review, in hours. | | `PullRequestDetail.medianResponseTime` | Median Response Time | Median response time, the middle value of time from PR opening to first review, in hours. | | `PullRequestDetail.p90ResponseTime` | P90 Response Time | The 90th time from PR opening to the first review, in hours. | | `PullRequestDetail.minResponseTime` | Min Response Time | Minimum time from PR opening to first review, in hours. | | `PullRequestDetail.maxResponseTime` | Max Response Time | Maximum time from PR opening to first review, in hours. | | `PullRequestDetail.minFirstReviewedAt` | Min First Reviewed at | UNIX timestamp when a pull request was first reviewed. | | `PullRequestDetail.totalReviewTime` | Total Review Time | The total time from PR opening to its merge or closure, in hours. | | `PullRequestDetail.avgReviewTime` | Avg Review Time | The average time from PR opening to its merge or closure, in hours. | | `PullRequestDetail.medianReviewTime` | Median Review Time | The median time from PR opening to its merge or closure, in hours. | | `PullRequestDetail.p90ReviewTime` | P90 Review Time | The 90th percentile time from PR opening to its merge or closure, in hours. | | `PullRequestDetail.minReviewTime` | Min Review Time | The quickest time from PR opening to its merge or closure, in hours. | | `PullRequestDetail.maxReviewTime` | Max Review Time | The slowest time from PR opening to its merge or closure, in hours. | | `PullRequestDetail.minApprovedAt` | Min Approved at | The earliest approval UNIX timestamp for pull requests. | | `PullRequestDetail.totalIntegrationTime` | Total Integration Time | The total time from approval of the PR until its merge/closure, in hours.. | | `PullRequestDetail.avgIntegrationTime` | Avg Integration Time | The average time from approval of the PR until its merge/closure, in hours. | | `PullRequestDetail.medianIntegrationTime` | Median Integration Time | The median time from approval of the PR until its merge/closure, in hours. | | `PullRequestDetail.p90IntegrationTime` | P90 Integration Time | The 90th percentile time from approval of the PR until its merge/closure, in hours. | | `PullRequestDetail.minIntegrationTime` | Min Integration Time | The quickest time from approval of the PR until its merge/closure, in hours. | | `PullRequestDetail.maxIntegrationTime` | Max Integration Time | The slowest time from approval of the PR until its merge/closure, in hours. | | `PullRequestDetail.minMergedAt` | Min Merged at | The UNIX timestamp of the earliest merged time. | | `PullRequestDetail.totalClosingTime` | Total Closing Time | The total closing time for pull requests closed without merging, in hours. | | `PullRequestDetail.avgClosingTime` | Avg Closing Time | The average closing time for pull requests closed without merging, in hours. | | `PullRequestDetail.medianClosingTime` | Median Closing Time | The median closing time for pull requests closed without merging, in hours. | | `PullRequestDetail.p90ClosingTime` | P90 Closing Time | The 90th percentile of closing time for pull requests closed without merging. | | `PullRequestDetail.minClosingTime` | Min Closing Time | The minimum UNIX timestamp of closing time for pull requests closed without merging. | | `PullRequestDetail.maxClosingTime` | Max Closing Time | The maximum UNIX timestamp for pull requests closed without merging. | | `PullRequestDetail.minClosedAt` | Min Closed at | The minimum UNIX timestamp of when a pull request was closed. | | `PullRequestDetail.totalCommentsCount` | Total Comments Count | The total number of comments across pull requests. | | `PullRequestDetail.avgCommentsCount` | Avg Comments Count | The average number of comments on pull requests. | | `PullRequestDetail.minCommentsCount` | Min Comments Count | The minimum number of comments on pull request. | | `PullRequestDetail.maxCommentsCount` | Max Comments Count | The maximum number of comments on pull request. | | `PullRequestDetail.totalCommitsCount` | Total Commits Count | The total number of commits across pull requests. | | `PullRequestDetail.avgCommitsCount` | Avg Commits Count | The average number of commits in pull requests. | | `PullRequestDetail.minCommitsCount` | Min Commits Count | The minimum number of commits on pull requests. | | `PullRequestDetail.maxCommitsCount` | Max Commits Count | The maximum number of commits on pull requests. | | `PullRequestDetail.totalWorkTypeNew` | Total Work Type New | The total lines of code of new work done across pull requests. | | `PullRequestDetail.workTypeNewPercentage` | Work Type New Percentage | The percentage of new work relative to the total code change size. | | `PullRequestDetail.totalWorkTypeMaintenance` | Total Work Type Maintenance | The total lines of code of maintenance work done across pull requests. | | `PullRequestDetail.workTypeMaintenancePercentage` | Work Type Maintenance Percentage | The percentage of maintenance work relative to the total code change size. | | `PullRequestDetail.totalWorkTypeReworkOwn` | Total Work Type Rework Own | The total lines of code of rework of the author's own code done on pull requests. | | `PullRequestDetail.workTypeReworkOwnPercentage` | Work Type Rework Own Percentage | The percentage of rework of the authors's own code relative to the total code change size. | | `PullRequestDetail.totalWorkTypeReworkOthers` | Total Work Type Rework Others | The total lines of code of other contributors rework code done on pull requests. | | `PullRequestDetail.workTypeReworkOthersPercentage` | Work Type Rework Others Percentage | The percentage of rework of other contributors code relative to the total code change size. | | `PullRequestDetail.totalCodeChangeSize` | Total Code Change Size | The total number of lines of code changed (added, removed, or modified) in the pull request, including overlapping lines counted multiple times. | | `PullRequestDetail.avgCodeChangeSize` | Avg Code Change Size | The average number of lines of code changed (added, removed, or modified) in pull requests. | | `PullRequestDetail.minCodeChangeSize` | Min Code Change Size | The minimum number of lines of code changed (added, removed, or modified) in pull requests. | | `PullRequestDetail.maxCodeChangeSize` | Max Code Change Size | The maximum number of lines of code changed (added, removed, or modified) in pull requests. | | `PullRequestDetail.totalFilesCount` | Total Files Count | The total number of files changed across pull requests. | | `PullRequestDetail.avgFilesCount` | Avg Files Count | The average number of files changed per pull request. | | `PullRequestDetail.minFilesCount` | Min Files Count | The minimum number of files changed across pull requests. | | `PullRequestDetail.maxFilesCount` | Max Files Count | The maximum number of files changed across pull requests. | | `PullRequestDetail.totalReviewedFileCount` | Total Reviewed File Count | The total number of files that received a review in pull requests. | | `PullRequestDetail.avgReviewedFileCount` | Avg Reviewed File Count | The average number of files reviewed for pull requests. | | `PullRequestDetail.minReviewedFileCount` | Min Reviewed File Count | The minimum number of files reviewed in pull requests. | | `PullRequestDetail.maxReviewedFileCount` | Max Reviewed File Count | The maximum number of files reviewed in pull requests. | | `PullRequestDetail.reviewCoverage` | Review Coverage | The percentage of files that received at least one code review comment relative to the total number of files changed. | | `PullRequestDetail.totalReviewersCount` | Total Reviewers Count | The total number of reviewers involved across pull requests. | | `PullRequestDetail.avgReviewersCount` | Avg Reviewers Count | The average number of reviewers for pull requests. | | `PullRequestDetail.minReviewersCount` | Min Reviewers Count | The minimum number of reviewers for pull requests. | | `PullRequestDetail.maxReviewersCount` | Max Reviewers Count | The maximum number of reviewers for pull requests. | | `PullRequestDetail.totalReviewCycles` | Total Review Cycles | The total number of times pull requests go back and forth between the author and reviewers for additional changes. | | `PullRequestDetail.avgReviewCycles` | Avg Review Cycles | The average number of review cycles for pull requests. | | `PullRequestDetail.minReviewCycles` | Min Review Cycles | The minimum number of review cycles for pull requests. | | `PullRequestDetail.maxReviewCycles` | Max Review Cycles | The maximum number of review cycles for pull requests. | | `PullRequestDetail.count` | Count | The total count of pull requests. | | `PullRequestDetail.allCount` | All Count | The cumulative count of all pull requests across all time. | | `PullRequestDetail.allMerged` | All Merged | The cumulative count of merged pull requests across all time. | | `PullRequestDetail.allClosed` | All Closed | The cumulative count of closed pull requests across all time. | ## Dimensions | Name | Title | Description | | ------------------------------------------------- | ------------------------------------ | ---------------------------------------------------------------------------------------------------------------------- | | `PullRequestDetail.timeInterval` | Opening Time | The time when the pull request was opened. | | `PullRequestDetail.timeIntervalLastUpdatedAtTime` | Last Updated Time | The timestamp when the pull request was last updated, obtained from the repository service. | | `PullRequestDetail.mergedTimetimeInterval` | Merged Time | The timestamp when the pull request was merged. | | `PullRequestDetail.closedTimetimeInterval` | Closed Time | The timestamp when the pull request was closed. | | `PullRequestDetail.id` | Id | | | `PullRequestDetail.number` | Number | The associated pull requests ID, as provided by the repository service. | | `PullRequestDetail.title` | Title | The title of the pull request. | | `PullRequestDetail.workType` | Work Type | The type of work associated with the pull request, such as New, Maintenance, or Rework. | | `PullRequestDetail.state` | State | The state of the pull request, such as Open or Approved. | | `PullRequestDetail.cycleTime` | Cycle Time | The time from first commit to merge or closure of pull requests, in hours. | | `PullRequestDetail.developmentTime` | Development Time | The time from the first commit to the opening the PR, in hours. | | `PullRequestDetail.firstCommittedAt` | First Commit At (Unix Timestamp) | The UNIX timestamp of the first commit made in the pull request. | | `PullRequestDetail.reviewRequestedAt` | Review Requested At (Unix Timestamp) | The UNIX timestamp when a review was first requested for the pull request. | | `PullRequestDetail.responseTime` | Response Time | The time taken from opening the PR to the first review, in hours. | | `PullRequestDetail.firstReviewedAt` | First Review At (Unix Timestamp) | The UNIX timestamp when the pull request was first reviewed. | | `PullRequestDetail.reviewTime` | Review Time | The total time from first review response to approval of the PR, in hours. | | `PullRequestDetail.approvedAt` | Approved At (Unix Timestamp) | The UNIX timestamp when the pull request was approved. | | `PullRequestDetail.integrationTime` | Integration Time | The time from approval of the PR until its merge/closure, in hours. | | `PullRequestDetail.mergedAt` | Merged At (Unix Timestamp) | The UNIX timestamp when the pull request was merged. | | `PullRequestDetail.closingTime` | Closing Time | The time taken to close the pull request, in hours. | | `PullRequestDetail.closedAt` | Closed At (Unix Timestamp) | The UNIX timestamp when the pull request was closed. | | `PullRequestDetail.commentsCount` | Comments Count | The number of comments made on the pull request. | | `PullRequestDetail.commitsCount` | Commits Count | The number of commits associated with the pull request. | | `PullRequestDetail.workTypeNew` | Work Type New | The total lines of code for newly added code for a pull request. | | `PullRequestDetail.workTypeMaintenance` | Work Type Maintenance | The total lines of code that are changes to code older than 3 months for a pull request. | | `PullRequestDetail.workTypeReworkOwn` | Work Type Rework Own | The total lines of code that are changes to the author's own code, that is less than 3 months old, for a pull request. | | `PullRequestDetail.workTypeReworkOthers` | Work Type Rework Others | The total lines of code that are changes to other people's code, that is less than 3 months old, for a pull request. | | `PullRequestDetail.codeChangeSize` | Code Change Size | The total size of the code changes made in the pull request. | | `PullRequestDetail.filesCount` | Files Count | The number of files affected by the pull request. | | `PullRequestDetail.reviewedFileCount` | Reviewed File Count | The number of files that were reviewed in the pull request. | | `PullRequestDetail.reviewersCount` | Reviewers Count | The number of reviewers assigned to the pull request. | | `PullRequestDetail.reviewCycles` | Review Cycles | The number of review cycles the pull request went through before being merged or closed. | ## Connected Cubes All fields belonging to the following cubes are also reachable from PullRequestDetail: * [Pull Request](/advanced/datastudio-data-model/models/pullrequestdetail.md) * [Pull Request Jira Issue](/advanced/datastudio-data-model/models/pullrequestjiraissue.md) * [Pull Request Event](/advanced/datastudio-data-model/models/pullrequestevent.md) * [Contributor](/advanced/datastudio-data-model/models/contributor.md) * [Team](/advanced/datastudio-data-model/models/team.md) * [CI Build](/advanced/datastudio-data-model/models/cibuild.md) * [CI Build Stage](/advanced/datastudio-data-model/models/cibuildstage.md) * [Planning Ticket Component](/advanced/datastudio-data-model/models/jiracomponent.md) * [Planning Ticket Custom Field](/advanced/datastudio-data-model/models/jiracustomfield.md) * [Epic](/advanced/datastudio-data-model/models/jiraepic.md) * [Planning Ticket Hierarchy Issues](/advanced/datastudio-data-model/models/jirahierarchyissues.md) * [Planning Ticket Hierarchy Issue Link](/advanced/datastudio-data-model/models/jiraissuehierarchylink.md) * [Planning Ticket](/advanced/datastudio-data-model/models/jiraissuedetail.md) * [Planning Ticket Event](/advanced/datastudio-data-model/models/jiraissueevent.md) * [Planning Ticket Label](/advanced/datastudio-data-model/models/jiralabel.md) * [Planning Sprint](/advanced/datastudio-data-model/models/jirasprint.md) * [Planning Ticket State Durations](/advanced/datastudio-data-model/models/jirastatedurations.md) * [Repositories](/advanced/datastudio-data-model/models/project.md) --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.logilica.com/advanced/datastudio-data-model/models/pullrequestdetail.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.