2.6 KiB
2.6 KiB
Proposal – Advanced Reporting & Visualization
Goal
Make reports more flexible through column selection and more insightful by adding graphical visualizations. All reports are displayed online first, with a clear path towards future PDF export.
1. Column Selection When Creating Reports
1.1 Report Configuration
Add an extra step “Report Content” when creating a report:
- Checkbox list of available columns
- Drag & drop to define column order
- Option to save as template for reuse
1.2 Column Groups
Columns are grouped for clarity:
Job Information
- Job name
- Job type
- Repository / Target
Status
- Last run status
- Result (Success / Warning / Failed)
- Exit code
Time & Performance
- Start time
- Duration
- Average duration
Data
- Data processed
- Data size
- Change rate
Reliability
- Consecutive failures
- Last successful run
2. Graphical Reports (Online Dashboard)
2.1 Summary View
Always shown at the top of a report:
KPI Cards
- Total jobs
- Successful jobs
- Failed jobs
- Warning jobs
- Success rate (%)
2.2 Chart Proposals
Status Distribution
- Donut / pie chart: Success vs Warning vs Failed
Trends Over Time
- Line chart: success rate per day
- Line chart: number of failures per day
Performance
- Bar chart: average runtime per job
- Bar chart: largest data volumes per job
Reliability
- Heatmap: failures per job per day
- Bar chart: top N jobs with most failures
2.3 Interaction
- Hover tooltips with detailed values
- Clicking a chart filters the table view
- Time range selector:
- Last 24 hours
- Last 7 days
- Last 30 days
- Custom range
3. Raw Data vs Graphical View
3.1 Tabs per Report
- Overview – KPIs and charts only
- Details – table with selected columns
- History – long-term trends
3.2 Filtering & Sorting
- Filter by status
- Filter by job
- Sort by duration, date, or failures
4. Preparation for PDF Export (Future)
4.1 Layout Guidelines
- Fixed A4-friendly layout
- Maximum two charts per row
- Dark text on light background
- Non-interactive chart rendering in PDF mode
4.2 PDF-Ready Structure
- Title and period
- Executive summary (KPIs)
- Status overview
- Trend analysis
- Optional detail tables
5. Technical Principles (High-Level)
- Store report definitions as JSON:
- Selected columns
- Chart types
- Filters
- Client-side chart rendering
- Same report definition reusable for PDF rendering later
Result
- Flexible, audience-focused reports
- Faster insight through visual summaries
- Clean transition to professional PDF reports without redesign