Dashboard | <?php echo APP

isLoggedIn()) { redirectTo('login.php'); } $currentUser = $auth->getCurrentUser(); $db = Database::getInstance(); // Get dashboard statistics $userCount = $db->query("SELECT COUNT(*) as count FROM users")->fetch_assoc()['count']; $attributeCount = $db->query("SELECT COUNT(*) as count FROM attributes")->fetch_assoc()['count']; $statisticCount = $db->query("SELECT COUNT(*) as count FROM statistics")->fetch_assoc()['count']; $panelCount = $db->query("SELECT COUNT(*) as count FROM panel_data")->fetch_assoc()['count']; $surveyCount = $db->query("SELECT COUNT(*) as count FROM surveys WHERE created_by = " . $_SESSION['user_id'])->fetch_assoc()['count']; $projectCount = $db->query("SELECT COUNT(*) as count FROM projects WHERE created_by = " . $_SESSION['user_id'])->fetch_assoc()['count']; // Calculate alignment score $alignmentScore = 'N/A'; if ($panelCount > 0) { $columnCheck = $db->query("SHOW COLUMNS FROM statistic_combinations LIKE 'actual_percentage'"); if ($columnCheck->num_rows > 0) { $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; $alignmentScore = max(0, 100 - $rmse); } } } ?> Dashboard | <?php echo APP_NAME; ?>

Users

Total registered users

Attributes

Demographic attributes

Statistics

Statistical targets

Panel Size

Synthetic panelists

Surveys

Your surveys

Projects

Research projects