Query editor
-- Daily Claims by ProgramWITH all_claims AS (SELECT * FROM query_6325907UNION ALLSELECT * FROM query_6326470UNION ALLSELECT * FROM query_6326500UNION ALLSELECT * FROM query_6326514)SELECTdate,program,partner,chain,SUM(num_claims) as total_claims,SUM(total_claimed) as total_fluid_claimedFROM all_claimsWHERE exclude_expense = falseGROUP BY 1, 2, 3, 4ORDER BY date DESC, total_fluid_claimed DESC