Chart controls and notes
Showing the first 20 categories. Open full screen to explore all 496 categories.
Finance needs to allocate costs and perform chargeback for charges for all applications that come from different geographic locations and are in different currencies.
Column names from the source use case.
Showing the first 20 categories. Open full screen to explore all 496 categories.
Showing 100 of 500 rows. Scroll inside the table to see more.
select tags->>$3::text as application_id,
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,
billing_account_id,
billing_account_name,
billing_currency,
sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
and billing_period_end < $2::timestamptz
group by 1, 2, 3, 4, 5
order by total_billed_cost desc nulls last, application_id nulls last, service_provider_name, billing_account_id
limit 500SELECT Tags["ApplicationId"], ServiceProviderName, BillingAccountId, BillingAccountName, BillingCurrency, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ? GROUP BY Tags["ApplicationId"], ServiceProviderName, BillingAccountId, BillingAccountName, BillingCurrency