Getting aggregate sub-values in aggregate query
SELECT  ...,
        SUM(s.status_id = 'OPEN') AS total_open_credited,
        ...
    FROM ...
    WHERE ...
    GROUP BY DATE(s.created)   -- a simplification
    ORDER BY ...


Explanation:  s.status_id = 'OPEN' is a boolean expression that evaluates to TRUE or FALSE.  TRUE is 1; FALSE is 0.  Then SUM correctly tallies what you asked for.