Locate provider-issued credit memos in billing data and analyze how each one reduces net spend.
This query uses the ProviderName column. ProviderName is deprecated in v1.3 and will be removed in v1.4.
Column names from the source use case.
1 row. Scroll inside the table to see more.
select provider_name as provider_name,
invoice_issuer_name as invoice_issuer_name,
billing_account_id as billing_account_id,
billing_period_start as billing_period_start,
count(*) as credit_line_count,
sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
and charge_period_end < $2::timestamptz
and charge_category = 'Credit'
group by provider_name, invoice_issuer_name, billing_account_id, billing_period_start
order by total_billed_cost asc nulls last, provider_name, invoice_issuer_name
limit 500SELECT
ProviderName,
InvoiceId,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
AND ChargeCategory = 'Credit'
GROUP BY
ProviderName,
InvoiceId