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

QFD Knowledgebase

Daily Claim Volume

Analytics

SQL

Related content