Identify sources of billed cost

This query uses the ProviderName, and PublisherName columns. ProviderName and PublisherName are deprecated in v1.3 and will be removed in v1.4.

FOCUS Versions

v1.2

Context

Reconcile billing data from vendors, provider marketplaces, and cloud service providers to pinpoint true spend and eliminate duplicate charges.

FOCUS SQL Query

SELECT 
    ProviderName,
    PublisherName,
    InvoiceIssuerName,
    InvoiceId,
    SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
GROUP BY
    ProviderName,
    PublisherName,
    InvoiceIssuerName,
    InvoiceId