Analyze credit memos v1.3 | FOCUS Explorer

Source: FOCUS 1.0 sample
Result rows: 1
Status: Adapted to v1.0
Execution: PrecomputedRead-only
Result snapshot (UTC): 2026-10-11

Total credits (ChargeCategory = Credit) per service provider and invoice. v1.0 has no InvoiceId, so credits are grouped by invoice issuer, billing account and billing period as an invoice proxy. In the sample all 282 credit rows are AWS promotional credits on one billing account and period.

Column adaptations (2)

Credits by invoice (billing account)

Query results
Service provider name	Invoice issuer name	Billing account id	Billing period start	Credit rows	Total billed cost
AWS	Amazon Web Services, Inc.	1234567890123	2026-03-01	282	-$1,196.45

1 row. Scroll inside the table to see more.

Default parameters use the precomputed result, generated as the read-only focus_reader role.

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

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 500

Parameters: $1 = period_start, $2 = period_end

Original FOCUS SQL

SELECT 
    ServiceProviderName,
    InvoiceId,
    SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
AND ChargeCategory = 'Credit'
GROUP BY
    ServiceProviderName,
    InvoiceId

Service provider name

Invoice issuer name

Billing account id

Billing period start

Credit rows

Total billed cost

AWS

Amazon Web Services, Inc.

1234567890123

2026-03-01

282

-$1,196.45

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 500

SELECT ServiceProviderName, InvoiceId, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ? AND ChargeCategory = 'Credit' GROUP BY ServiceProviderName, InvoiceId