report.ex

def date_and_count1(query, "month" = period, status) do
  from s in query, select:
    [fragment("ROUND(100.0 * SUM(CASE WHEN status = ? THEN 1 ELSE 0 END) / COUNT(*), 2) AS share", ^status),
    fragment("date_trunc(?, created_at) AS date_trunc_created_at", "month")],
    group_by: fragment("date_trunc(?, created_at)", "month")
end

def date_and_count2(query, "month" = period, status) do
  from s in query, select:
    [fragment("ROUND(100.0 * SUM(CASE WHEN status = ? THEN 1 ELSE 0 END) / COUNT(*), 2) AS share", ^status),
    fragment("date_trunc(?, created_at) AS date_trunc_created_at", ^period)],
    group_by: fragment("date_trunc(?, created_at)", ^period)
end