Daily Claim Volume

Owned by Devan Robertson
Last updated: Jul 18, 2024
1 min read
Description:Provides total count of incoming claims by day, Claim Type, and Claim Category.  Does not include abandoned claims.
Sources:Claims

It is important that you always include tenantID in your WHERE clause.  Not doing so will result in poor performance.  

WHERE tenantid = 'YOURTENANTIDHERE'

SQL

SELECT
    to_date(createdate) AS "Create Date",
    claimtype AS "Claim Type",
    claimcategory AS "Claim Category",
    count(*) as "Claims"
FROM
    claims AS d
WHERE
    tenantid='YOURTENANTIDHERE'
    AND createdate=:daterange
    and claimstate != 'Other'
GROUP BY
    "Create Date", claimtype, claimcategory
ORDER BY
    "Create Date" DESC, claimtype DESC, claimcategory DESC