Epic: Issues Dashboard

### Overview
We need to manage the work for the issue dashboard, so that we can prioritize and recruit.

### Action Items
- [ ] Review prior work including Wiki
- [x] Go the issue tab for issue dashboard and copy all of the links in the issue to a comment in the bottom of the issue and indicate whether they are public or private.
- [x] Copy all of the link lists from the issues into a comment on this issue
- [x] Remove duplicates
- [ ] ~Remove the public private status~
- [ ] Revise Issues Dashboard Roadmap

### Resources/Instructions

- [P: HfLA Dashboards: Project Board, Issues](https://github.com/orgs/hackforla/projects/88/views/2)
- [HfLA website: HfLA Dashboard Development Roadmap](https://docs.google.com/document/d/1Ejsq97zWh4smPxXzwFbWg3_8IZNlfkoEKGPteiG2PdM/edit)
- [HfLA website: Dashboard Roadmap: Issues](https://docs.google.com/document/d/1vA3So2axc7F60pjWrbFAiq0_Wnjv4Utlu8d1aLUPLH0/edit)
- All Dashboards Epic: https://github.com/hackforla/website/issues/6614

### Time Sensitive
- https://github.com/hackforla/website/issues/6454

### V1
- https://github.com/hackforla/website/issues/2698
- [GitHub website repo, issue tab, with filter: is:issue is:open no:project](https://github.com/hackforla/website/issues?q=is%3Aissue+is%3Aopen+no%3Aproject)
- [GitHub website repo, issue tab, with filter: is:open is:issue label:"ready for dev lead"](https://github.com/hackforla/website/issues?q=is%3Aopen+is%3Aissue+label%3A%22ready+for+dev+lead%22)

### V2 Dashboard (looker)
- [Live Project Board Issues Dashboard (Current)](https://lookerstudio.google.com/u/2/reporting/6410c484-f38f-44ba-b4ed-c29a6b2a081b/)

#### Documentation
- WIKI https://github.com/hackforla/data-science/wiki/Interactive-Looker-Dashboard-for-the-HackforLA.org-Website-Team

#### Data
- Spreadsheet: [GitHub Project Board Issues - Data Analysis](https://docs.google.com/spreadsheets/d/1aJ0yHkXYMWTtMz6eEeolTLmAQOBc2DyptmR5SAmUrjM) - all the issue by issue data that looker uses to display the dashboard this spreadsheet is located in located in HackforLA.org website > HackforLA.org website folder > 5 - Data Science > GitHub Data Analysis > Dashboard
- Spreadsheet: [GitHub Project Board Issues - Data Analysis](https://docs.google.com/spreadsheets/d/1aJ0yHkXYMWTtMz6eEeolTLmAQOBc2DyptmR5SAmUrjM/edit?usp=sharing)
- spreadsheet: [GitHub Project Board Issues - Data Analysis, Dataset 2 (locked)](https://docs.google.com/spreadsheets/d/1aJ0yHkXYMWTtMz6eEeolTLmAQOBc2DyptmR5SAmUrjM/edit#gid=516248185)
- spreadsheet: [GitHub Project Board Issues - Data Analysis, Missing Label Audit tab](https://docs.google.com/spreadsheets/d/1aJ0yHkXYMWTtMz6eEeolTLmAQOBc2DyptmR5SAmUrjM/edit#gid=1516123154)
- Spreadsheet: [Labels for Weekly Label Check](https://docs.google.com/spreadsheets/d/1-ltg0qMeZSgOnqrCU0nKUDQd1JOXTMWrNTK63VZjXdk/edit#gid=0) - the dashboard uses this to indicate authorized labels
- [See the current ignore labels on the Repo: website, Tab: labels `ignore...`](https://github.com/hackforla/website/labels?q=ignore)
- We're in the process of changing from weekly labels check to [Public - Website Labels 'Source of Truth](https://docs.google.com/spreadsheets/d/1mORvRtje95Z1Hhg0XMtcIkRD3QfOdAQLmTtwAhHKuq8/edit?usp=sharing)

#### GitHub Actions that support Dashboard
- https://github.com/hackforla/live-dashboard-automation/actions/workflows/schedule_run_to_update_data.yaml
- https://github.com/hackforla/live-dashboard-automation/blob/main/.github/workflows/schedule_run_to_update_data.yaml#L56-L58
- [Repo: live-dashboard-automation](https://github.com/hackforla/live-dashboard-automation) - former name: onboarding-github-issues
- [Repo: live-dashboard-automation, tab: Actions](https://github.com/hackforla/live-dashboard-automation/actions)
- [Repo: live-dashboard-automation, tab: code /.github/workflows](https://github.com/hackforla/live-dashboard-automation/tree/main/.github/workflows)
- [Repo: live-dashboard-automation, tab: code .env file](https://github.com/hackforla/live-dashboard-automation/blob/main/.env)

### Google Drive and Folder Links
- folder: HackforLA.org website > HackforLA.org website folder > 5 - Data Science > GitHub Data Analysis > [Dashboard](https://drive.google.com/drive/folders/1OoCzO58nhcGtd4My9lvbPCAVNf_fK5hR)
- folder: Data Science (community of practice) > Data Science (community of practice) > [labels audit](https://drive.google.com/drive/u/0/folders/1l8bMfhmUPG1O3nCLgvIE7jd_HlqAIb1s)

### Google Cloud
- [Google Cloud Console](https://console.cloud.google.com/cloud-resource-manager?authuser=4) - We try not to use AWS or Google Cloud for this project wherever possible. However, if its is deemed necessary and the Admin of Hack for LA approves it you would use it via webadmin@hackforla.org

### Related Projects
- Default Labels
- https://github.com/hackforla/ops/issues/15 (we will want the dashboard to work for new teams straight away, so having default labels will ensure that)
- Label Survey https://github.com/hackforla/data-science/issues/160
- Google Drive folder: Data Science (community of practice) > Data Science (community of practice) > [labels audit](https://drive.google.com/drive/u/0/folders/1l8bMfhmUPG1O3nCLgvIE7jd_HlqAIb1s)
- Google Sheet: [Label.csv](https://docs.google.com/spreadsheets/d/1zkUolP0zm4qndsLBhZr0U8fEpUZgpodboF55BLvRN7U/edit?gid=323636639#gid=323636639) - a Google Sheet version of the label.csv file
- CSV file: [label.csv](https://drive.google.com/file/d/14eFq1HL-7huoUb58xlw0gat0WMmeOFk5/view?usp=drive_link) - a file created by the script of labels.
- Google Sheet: [combined.csv](https://docs.google.com/spreadsheets/d/1KOCPa4KPE9GPwVdwkUCyvXwLLqUF2TP2rDlOodN62xc/edit?gid=0#gid=0) - a Google Sheet version of the label.csv file
- CSV file: [combined.csv](https://drive.google.com/file/d/1sFqdDB93_tt38rgnqTx42pTdD7ivfJJ5/view?usp=drive_link) - a file created by the script of labels.
- [Labels Survey Analysis.pdf](https://github.com/hackforla/data-science/files/10762498/Labels.Survey.Analysis.pdf) - Author [Joshua Susanto](https://github.com/jossus657)
- [Repo: data-science, code: labels-survey](https://github.com/hackforla/data-science/tree/160-survey-repo-labels/labels-survey)
- Folder for Labels Survey project: https://github.com/hackforla/data-science/tree/main/labels-survey
- Getting labels: https://github.com/hackforla/data-science/blob/main/labels-survey/get_labels.py
- Getting the repositories: https://github.com/hackforla/data-science/blob/main/labels-survey/repos.py
- Getting the output: https://github.com/hackforla/data-science/blob/main/labels-survey/output.csv
- Label analysis: https://github.com/hackforla/data-science/blob/main/labels-survey/Label_Analysis.ipynb

### Tutorials/Helpfiles and Community Discussion boards
- Presentation: [GitHub Class on Dashboard Creation 11/13/2023](https://docs.google.com/presentation/d/1hZCNMZewl4L_so1ceGMOuP0mTbaBkUuwzAbBPgcGYfU) - made by the creator of the original dashboard
- A early version of the presentation [Labels Survey Analysis.pdf](https://github.com/hackforla/data-science/files/10762498/Labels.Survey.Analysis.pdf)
- Tutorial: https://www.datacamp.com/tutorial/how-to-analyze-data-in-google-sheets-with-python-a-step-by-step-guide
- GitHub Docs: [REST API endpoints for Projects (classic)](https://docs.github.com/en/rest/projects) - this was used to create the dashboard, but we migrated to the new project boards, so this guidance should be used to understand the current code and help rewrite it to use new project board technical requirements
- GitHub Docs: [Managing labels, Applying a label](https://docs.github.com/en/issues/using-labels-and-milestones-to-track-work/managing-labels#applying-a-label)
- GitHub Community Discussions: [Pip dependencies not getting cached even after successful restore ](https://github.com/orgs/community/discussions/26096)
- Hack for LA website wiki documentation - written by website team
- [How to create issues](https://github.com/hackforla/website/wiki/How-to-create-issues)
- [How-to-read-and-interpret-labels](https://github.com/hackforla/website/wiki/How-to-read-and-interpret-labels)
- YouTube: [Google Sheets API Automation in Python](https://www.youtube.com/watch?v=3wC-SCdJK2c)
- YouTube: [Google Sheets API Automation in Python at 250s](https://www.youtube.com/watch?v=3wC-SCdJK2c&t=250s) the presenter discusses the process of enabling the Google Sheets API and creating the necessary credentials for API access.
- YouTube: [Update Google Sheets Using A Service Account With Google Sheets API In Python 🐍](https://www.youtube.com/watch?v=sVURhxyc6jE&t=2s)
- Youtube: [How to cache python dependencies to speed up GitHub workflows](https://www.youtube.com/watch?v=6WemQlusrJQ&t=1253s)
- PythonDocs: 3.13.2 Documentation » The Python Standard Library » Internet Protocols and Support » urllib.parse — [Parse URLs into components](https://docs.python.org/3/library/urllib.parse.html)
- Tutorial: [Manually Trigger a GitHub Action with Workflow Dispatch](https://leonardomontini.dev/github-action-manual-trigger/) - Guide on adding workflow dispatch event/button
- DuckDB Documentation: [Python API Overview for the DuckDB product](https://duckdb.org/docs/api/python/overview.html)
- Shillelagh Documentation: [Shillelagh Python library and CLI Overview](https://shillelagh.readthedocs.io/en/latest/index.html) a Python library and CLI that allows you to query many resources (APIs, files, in memory objects) using SQL.
- Tutorial and Calculator: - [https://crontab.guru](https://crontab.guru) Resource for Figuring Out Cron Job Expression