These cubes provide direct access to work tracking data from your connected providers (GitHub, Jira, etc.). Unlike the flow cubes which use pre-computed materialized views, these cubes query live tables for real-time data.
Source Table: issues
Description: Work items and issues tracked across GitHub, GitLab, Jira, and other platforms.
Dimension Type Description idstring Unique issue ID providerstring Source provider (github, jira, etc.) numbernumber Issue number titlestring Issue title statestring Current state (open, closed) typestring Issue type (feature, bug, chore, incident, discovery) authorUsernamestring Author’s username assigneeCountnumber Number of assignees commentCountnumber Number of comments createdAttime When created closedAttime When closed firstResponseAttime First response timestamp
Measure Description countTotal issues openCountOpen issues closedCountClosed issues featureCountFeature issues bugCountBug issues choreCountChore issues incidentCountIncident issues discoveryCountDiscovery issues
Measure Description avgLeadTimeDaysAverage time from created to closed medianLeadTimeDaysMedian time from created to closed avgBugLeadTimeHoursAverage bug resolution time avgDiscoveryLeadTimeDaysAverage discovery cycle time medianDiscoveryLeadTimeDaysMedian discovery cycle time p90DiscoveryLeadTimeDays90th percentile discovery time
Measure Description avgFirstResponseDaysAverage time to first response medianFirstResponseDaysMedian time to first response avgDiscoveryFirstResponseDaysAverage first response on discoveries
Measure Description plannedCountFeatures + chores + discoveries unplannedCountBugs + incidents plannedPercentage% planned work unplannedPercentage% unplanned work
Measure Description openDiscoveryCountOpen discoveries closedDiscoveryCountClosed discoveries discoveryCloseRate% discoveries closed discoveryValidationRate% validated into features discoveryDiscardRate% invalidated or discarded validatedDiscoveryCountValidated discoveries invalidatedDiscoveryCountInvalidated discoveries featuresFromDiscoveriesFeatures created from discoveries discoveryQualityIndex% validated features shipped
Sprint Planning: Track open issues by typeTriage Efficiency: Measure first response timesWork Mix Analysis: Compare planned vs unplanned workDiscovery Process: Measure validation rates
Source Table: pull_requests
Description: Pull requests and merge requests tracked across GitHub, GitLab, and other platforms.
Dimension Type Description idstring Unique PR ID providerstring Source provider numbernumber PR number titlestring PR title statestring Current state (open, closed) mergedstring Whether merged (‘true’/‘false’) isDraftstring Draft PR flag authorUsernamestring Author’s username headBranchstring Source branch baseBranchstring Target branch additionsnumber Lines added deletionsnumber Lines deleted changedFilesnumber Files changed commitsnumber Number of commits reviewerCountnumber Number of reviewers commentCountnumber Number of comments createdAttime When created mergedAttime When merged firstReviewAttime First review timestamp firstApprovalAttime First approval timestamp
Measure Description countTotal PRs openCountOpen PRs mergedCountMerged PRs closedCountClosed PRs (not merged) draftCountDraft PRs
Cycle time = PR created → PR merged
Measure Description avgCycleTimeDaysAverage cycle time medianCycleTimeDaysMedian cycle time p90CycleTimeDays90th percentile avgCycleTimeHoursAverage in hours medianCycleTimeHoursMedian in hours
Review time = PR created → First review
Measure Description avgReviewTimeDaysAverage time to first review medianReviewTimeDaysMedian time to first review avgReviewTimeHoursAverage in hours medianReviewTimeHoursMedian in hours
Approval time = PR created → First approval
Measure Description avgApprovalTimeDaysAverage time to approval avgApprovalTimeHoursAverage in hours medianApprovalTimeHoursMedian in hours avgApprovalToMergeMsApproval to merge time medianApprovalToMergeHoursMedian approval to merge
Measure Description totalAdditionsTotal lines added avgAdditionsAverage lines added per PR totalDeletionsTotal lines deleted avgDeletionsAverage lines deleted per PR totalChangedFilesTotal files changed avgChangedFilesAverage files per PR totalCommitsTotal commits avgCommitsAverage commits per PR
Measure Description medianPrSizeMedian PR size (lines) p90PrSize90th percentile size smallPrCountPRs < 400 lines largePrCountPRs >= 400 lines
Code Review Efficiency: Track review and approval timesPR Size Analysis: Identify oversized PRsMerge Rate: Compare merged vs closed PRsTeam Velocity: Track throughput over time
Source Table: deployments
Description: Deployments tracked across GitHub Actions, GitLab CI, and other platforms.
Dimension Type Description idstring Unique deployment ID providerstring Source provider refstring Git ref (branch/tag) shastring Git commit SHA environmentstring Target environment taskstring Deployment task currentStatusstring Current status isProductionstring Production flag (‘true’/‘false’) isTransientstring Transient deployment flag creatorUsernamestring Who triggered it createdAttime When triggered currentStatusUpdatedAttime Last status update
Measure Description countTotal deployments productionCountProduction deployments stagingCountStaging deployments successCountSuccessful deployments failureCountFailed deployments pendingCountPending deployments
Measure Description productionSuccessCountSuccessful production deploys productionFailureCountFailed production deploys
Measure Description changeFailureRate% failed deployments (all) productionFailureRate% failed production deployments
Deployment Frequency: Track deploys over timeEnvironment Comparison: Compare staging vs productionFailure Analysis: Monitor failure rates by environmentRelease Tracking: Correlate deployments with releases
All three cubes support these relationships:
Join Description ProjectsFilter by project TeamsFilter by team (via project-team links) UsersFilter by author/creator
Issues by team:
measures: [Issues.count, Issues.openCount]
PR cycle time by project:
measures: [PullRequests.medianCycleTimeDays]
dimensions: [Projects.name]
Production deployment success rate:
measures: [Deployments.productionCount, Deployments.productionFailureRate]
dimensions: [Deployments.environment]
filters: [{ member: "Deployments.isProduction", operator: "equals", values: ["true"] }]
