Refining the Requirements for Skills Match Dashboard

[n2020h]

Overview

We need to gather previous relevant documentation of features and functions skills dashboard and refine requirements, so that we can develop it.

Action Items

• Bonnie will add links to prior known issues from other projects
• [ ]

Resources/Instructions

https://docs.google.com/spreadsheets/d/1SV0j3NKcjOpHuT3okyM36xwWA966hNA4N1zmqRtd8B8/edit#gid=11574199

[ExperimentsInHonesty]

Use Google App Script to poll GitHub label and issue APIs
write results to spreadsheet
use spreadsheet as data set for looker dashboard views

[ExperimentsInHonesty]

The intern dashboard https://lookerstudio.google.com/s/pvg4HLLgeiM

[n2020h]

Working on this issue on a feature branch: https://github.com/hackforla/data-science/tree/n2020h-issues-to-csv
Update: Used GH actions to create csv of issues and labels, see output file - issues.csv

[n2020h]

Connected output "issues.csv" to Google Sheets file: https://docs.google.com/spreadsheets/d/1LVOGU1aVcruOGAhi4C4U1wLqUeVovkx0AOKLnE2gAtg/edit?usp=sharing
Connected Google Sheets to Looker report:
https://lookerstudio.google.com/reporting/e5a6534d-edb8-41b4-a76a-832824e00d80

[n2020h]

Updating Google Sheets file to mirror source file for original dashboard. Current blockers:

1. How to access the functions to create the specific charts from original dashboard.
2. How to automatically connect PRs, projects to relevant issues. Which field(s) connects these?
   Currently, I've found links to specific issue links in various places in the json:
   Examples: issue_url, timeline_url, in the Body of PR and in Reactions

Working file: https://docs.google.com/spreadsheets/d/17gmu3U7_BaLMIVT6SfVY7qz-0yApbA1OaO0_3-Ri7Ko/edit?usp=sharing

[n2020h]

Looker dashboard in progress:
https://lookerstudio.google.com/s/v1h7xSJvLVs