Getting percentages for each day/category
SELECT Request_at AS `Date`, 
       SUM(CASE WHEN Status LIKE 'cancelled%'
                THEN Freq
                ELSE 0
                END) / SUM(Freq) AS `% cancel`
FROM source_table
GROUP BY Request_at