Description:	Provides total amount disputed, 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",
SUM(d.disputeamount) as "Dispute Amount"
FROM
disputes AS d
WHERE
tenant= 'YOURTENANTIDHERE'
AND createdate=:daterange
GROUP BY
"Create Date", type, category
ORDER BY
"Create Date" DESC, type DESC, category DESC

Daily Dispute Amount

SQL