db_query / documentations /wbts_capacity_doc.py
DavMelchi's picture
feat: improve streamlit docs and clean navigation icons
4d0d437
import streamlit as st
st.markdown(
"""
# WBTS Capacity Documentation
## 1. Objective
Analyze WBTS resource usage and classify capacity risk based on BB/CE comments.
## 2. When to use this tool
Use this page when planning WBTS upgrades or investigating BB/CE load pressure.
## 3. Input files and accepted formats
- Required: WBTS capacity report in `.csv`
- Data recommendation: at least 3 days, daily aggregated, WBTS-level export
## 4. Required columns/fields
Input CSV must contain the fields expected by `process_kpi.process_wbts_capacity.load_data`.
Typical outputs include `bb_comments` and `ce_comments`.
## 5. Step-by-step usage
1. Open `Capacity Analysis > WBTS Capacity BB and CE Analysis`.
2. Upload WBTS CSV report.
3. Set analysis days, threshold days, and threshold value.
4. Click `Analyze Data`.
5. Review table and BB/CE distributions.
6. Download Excel report.
## 6. Outputs generated
- analysis table with WBTS comments
- BB comments distribution chart
- CE comments distribution chart
- downloadable file: `WBTS_Analysis_Report.xlsx`
## 7. Frequent errors and fixes
- Parsing/analysis error.
- Fix: verify CSV structure and required columns.
- Empty comment distributions.
- Fix: ensure uploaded report contains valid WBTS-level KPI rows.
- Unexpected threshold behavior.
- Fix: confirm threshold values align with KPI scale.
## 8. Minimal reproducible example
- Input: WBTS daily aggregated CSV with >= 3 days.
- Action: run default parameters and analyze.
- Expected result: populated WBTS table + Excel download button.
## 9. Known limitations
- Relies on expected input schema from processing module.
- Very short time windows may produce weak conclusions.
- No geographic map visualization on this page.
## 10. Version and update date
- Documentation version: 1.0
- Last update: 2026-02-23
"""
)