Attributes
Define demographic and psychographic attributes for your synthetic panel
| Name | Type | Choices | Created By | Actions |
|---|---|---|---|---|
getCurrentUser(); $db = Database::getInstance(); // Get active section $activeSection = $_GET['section'] ?? 'attributes'; // Get all attributes $attributes = $db->query(" SELECT a.*, u.full_name as creator_name FROM attributes a LEFT JOIN users u ON a.created_by = u.id ORDER BY a.created_at DESC "); // Get all statistics with their attributes and combinations $statistics = $db->query(" SELECT s.*, u.full_name as creator_name, GROUP_CONCAT(DISTINCT a.name ORDER BY sa.id) as attribute_names FROM statistics s LEFT JOIN users u ON s.created_by = u.id LEFT JOIN statistic_attributes sa ON s.id = sa.statistic_id LEFT JOIN attributes a ON a.id = sa.attribute_id GROUP BY s.id ORDER BY s.created_at DESC "); // Get statistic checks (updated panel percentages) $statisticChecks = $db->query(" SELECT s.name as statistic_name, s.type, sc.combination_values, sc.percentage as target_percentage, sc.actual_percentage, u.full_name as creator_name, DATE_FORMAT(s.created_at, '%Y-%m-%d %H:%i:%S') as formatted_date FROM statistics s LEFT JOIN users u ON s.created_by = u.id JOIN statistic_combinations sc ON s.id = sc.statistic_id ORDER BY s.name, sc.id "); ?>
Define demographic and psychographic attributes for your synthetic panel
| Name | Type | Choices | Created By | Actions |
|---|---|---|---|---|
Define statistical distributions for synthetic panel generation
| Name | Type | Attributes | Created By | Actions |
|---|---|---|---|---|
Monitor panel alignment with target statistics
| Statistic | Combination | Target % | Panel % | Deviation % | Created By |
|---|---|---|---|---|---|
| % | % | % |