Dashboard

Attributes

query("SELECT COUNT(*) as count FROM attributes"); $attr_count = $attr_count_query ? $attr_count_query->fetch_assoc()['count'] : 0; ?>

Total registered attributes

Statistical Points

query("SELECT COUNT(*) as count FROM statistics"); $stats_count = $stats_query ? $stats_query->fetch_assoc()['count'] : 0; $combinations_query = $db->query("SELECT COUNT(*) as count FROM statistic_combinations"); $combinations_count = $combinations_query ? $combinations_query->fetch_assoc()['count'] : 0; $total_stats = $stats_count + $combinations_count; ?>

statistics, combinations

Panel Size

query("SELECT COUNT(*) as count FROM panel_data"); $panel_count = $panel_count_query ? $panel_count_query->fetch_assoc()['count'] : 0; ?>

Syndians

Alignment Score

query("SELECT COUNT(*) as count FROM panel_data"); $panelCount = $countCheck->fetch_assoc()['count']; if ($panelCount == 0) { $alignmentScore = 0; // No alignment for empty panel } else { // Make sure statistic_combinations table has actual_percentage column $columnCheck = $db->query("SHOW COLUMNS FROM statistic_combinations LIKE 'actual_percentage'"); if ($columnCheck->num_rows === 0) { // If column doesn't exist, alignment score is not available $alignmentScore = 'N/A'; } else { // Calculate RMSE (Root Mean Square Error) $query = $db->query(" SELECT SQRT(AVG(POW(percentage - actual_percentage, 2))) as rmse FROM statistic_combinations WHERE actual_percentage IS NOT NULL "); if ($query && $row = $query->fetch_assoc()) { $rmse = $row['rmse'] ?? 100; // Convert RMSE to alignment score (100 - RMSE) // Cap at 0 to avoid negative scores $alignmentScore = max(0, 100 - $rmse); } else { $alignmentScore = 'N/A'; } } } // Determine color class based on score $scoreClass = ($alignmentScore !== 'N/A' && $alignmentScore >= 95) ? 'score-good' : 'score-bad'; ?>

Panel quality (using RMSE)