Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enable join between pr_history and issues table #181

Open
tanishk2907 opened this issue Dec 16, 2024 · 0 comments
Open

Enable join between pr_history and issues table #181

tanishk2907 opened this issue Dec 16, 2024 · 0 comments
Assignees

Comments

@tanishk2907
Copy link

Metrics to track;

  • Average turnaround time of different tickets (cut by org name, Tech stack, ticket type etc)
  • Low engagement tickets ie multiple PRs raised but ticket not closed
  • Average PRs per Ticket

For this we need to join issues and pr_history table. Earlier, ccbp_tickets and pr tables were matched on ticket_url but ticket_url of pr table does not store the ticket link but the api links resulting in no way to match the 2 tables.

Objective : To enable join between the 2 tables either by adding ticket_link column in pr_history table or add issueID in the same.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants