what does the chart suppose to show? 0, 'avg_resolution_time' => null, 'min_resolution_time' => null, 'max_resolution_time' => null, 'solved_count' => 0, 'open_count' => 0, 'assigned_count' => 0, 'pending_count' => 0, 'closed_count' => 0 ]; // Fetch and calculate statistics based on your schema $stats_query = $wpdb->get_row(" SELECT COUNT(*) as total_tickets, AVG(TIMESTAMPDIFF(MINUTE, created_at, updated_at)) as avg_resolution_time, MIN(TIMESTAMPDIFF(MINUTE, created_at, updated_at)) as min_resolution_time, MAX(TIMESTAMPDIFF(MINUTE, created_at, updated_at)) as max_resolution_time, SUM(CASE WHEN status = 'solved' THEN 1 ELSE 0 END) as solved_count, SUM(CASE WHEN status = 'open' THEN 1 ELSE 0 END) as open_count, SUM(CASE WHEN status = 'assigned' THEN 1 ELSE 0 END) as assigned_count, SUM(CASE WHEN status = 'pending' THEN 1 ELSE 0 END) as pending_count, SUM(CASE WHEN status = 'closed' THEN 1 ELSE 0 END) as closed_count FROM $tickets_table ", ARRAY_A); // Merge with defaults to ensure all keys exist $stats = array_merge($default_stats, (array)$stats_query); // Convert minutes to hours for display function minutesToHours($minutes) { if ($minutes === null || $minutes === 0) return 'N/A'; $hours = floor($minutes / 60); $mins = $minutes % 60; return sprintf("%dh %02dm", $hours, $mins); } ?> Dashboard - RJL DeskTrack

Performance Reports

Total Tickets

All tickets in the system

Solved Tickets

Successfully solved tickets

Open Tickets

Tickets awaiting resolution

Avg. Resolution Time

Average time to resolve tickets

0): ?>