Testing
# aj_network_fixed_v4.py import pandas as pd import plotly.express as px import plotly.graph_objects as go # Config FILE_PATH = '/tmp/tt.xlsx' RESOURCE_COL = 'Resources' REGION_COL = 'Region' BEGIN_COL = 'BeginTime' DOWNTIME_COL = 'UnPlanDownTime' INC_COL = 'INC_Numbers' CRQ_COL = 'CRQ_Numbers' CMDB_MATCH_COL = 'CMDBMatchingWithAlertStatus' SLA_COL = 'SLAName' OUTPUT_HTML = '/tmp/alert_analysis_dashboard.html' TOP_N = 15 TOP_SLA = 20 # Load & Prepare df = pd.read_excel(FILE_PATH) df[BEGIN_COL] = pd.to_datetime(df[BEGIN_COL], errors='coerce') df[DOWNTIME_COL] = pd.to_timedelta(df[DOWNTIME_COL].astype(str).str.strip(), errors='coerce') df['DownTime_Minutes'] = df[DOWNTIME_COL].dt.total_seconds() / 60 df['Date'] = df[BEGIN_COL].dt.date ...