/
Daily Dispute Volume

Daily Dispute Volume

Description:Provides total count of disputes by day, Claim Type, and Claim Category.
Sources:Disputes

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",
    type AS "Claim Type",
    category AS "Claim Category",
    count(*) as "Disputes"
FROM
    disputes AS d
WHERE
    tenantid='YOURTENANTIDHERE'
    AND createdate=:daterange
GROUP BY
    "Create Date", type, category
ORDER BY
    "Create Date" DESC, type DESC, category DESC

Related content

Daily Dispute Amount
Daily Dispute Amount
More like this
Daily Claim Volume
Daily Claim Volume
More like this
Disputes Resolved by Day
Disputes Resolved by Day
More like this
Disputed Merchants
Disputed Merchants
More like this
Resolved Disputes - Detail
Resolved Disputes - Detail
More like this
Resolved Disputes - Summary
Resolved Disputes - Summary
More like this