Locate Service Provider-issued credit memos in billing data and analyze how each one reduces net spend.
Column names from the source use case.
1 row. Scroll inside the table to see more.
select case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end as service_provider_name,
invoice_issuer_name,
billing_account_id,
billing_period_start,
count(*) as credit_rows,
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 1, 2, 3, 4
order by total_billed_cost asc nulls last, service_provider_name, billing_account_id, billing_period_start
limit 500SELECT
ServiceProviderName,
InvoiceId,
SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
AND ChargeCategory = 'Credit'
GROUP BY
ServiceProviderName,
InvoiceId