documentations/dump_analysis_doc.py

import streamlit as st

st.markdown(
    """
# Dump Analytics Documentation

## 1. Objective
Explain the analytics dashboard displayed after generating full databases with stats.

## 2. When to use this tool
Use this documentation when reviewing post-generation charts and metrics for GSM/WCDMA/LTE (FDD/TDD).

## 3. Input files and accepted formats
No direct upload in this module.
It is fed by the `Generate All DBs and Show Stats` flow from `Apps > Generate Databases`.

## 4. Required fields
The analytics rely on precomputed structures in `utils.utils_vars` (site, GSM, WCDMA, LTE metrics).

## 5. Step-by-step usage
1. Open `Apps > Generate Databases`.
2. Upload a full dump `.xlsb`.
3. Click `Generate All DBs and Show Stats`.
4. Open Data and Chart tabs.
5. Use this page to interpret the displayed indicators.

## 6. Outputs generated
Displayed analytics include:
- site counts and band distributions
- GSM controller/LAC/TRX distributions
- WCDMA RNC/LAC/admin-state distributions
- LTE FDD/TDD distributions (bands, PCI, TAC, admin-state)

## 7. Frequent errors and fixes
- Empty analytics sections.
  - Fix: ensure full dump criteria are met before stats generation.
- Missing distributions.
  - Fix: verify source dump has required technology sheets.
- Inconsistent counts.
  - Fix: regenerate all DBs and ensure no parsing errors occurred.

## 8. Minimal reproducible example
- Input: full dump `.xlsb` containing 2G/3G/LTE sheets.
- Action: run `Generate All DBs and Show Stats`.
- Expected result: populated Data and Chart tabs with multi-technology metrics.

## 9. Known limitations
- Not exposed as a standalone top-level app page.
- Availability depends on successful preprocessing in database workflow.
- Large dumps can impact rendering speed.

## 10. Version and update date
- Documentation version: 1.0
- Last update: 2026-02-23
"""
)