Calculate unit-cost metrics (e.g., cost per GB of storage) to expose cost density and target optimizations that lower overall spend.
Column names from the source use case.
30 rows. Scroll inside the table to see more.
select (charge_period_start at time zone 'UTC')::date as charge_period_date,
round(sum(billed_cost) / nullif(sum(consumed_quantity), 0), 6) as cost_per_gb
from focus.cost_and_usage
where charge_description like '%transfer%'
and consumed_unit = 'GB'
group by (charge_period_start at time zone 'UTC')::date
order by charge_period_date asc
limit 500SELECT
CAST(ChargePeriodStart AS DATE) AS ChargePeriodDate,
SUM(BilledCost) / NULLIF(SUM(CAST(ConsumedQuantity AS DECIMAL(10, 2))), 0) AS CostPerGB
FROM focus_data_table
WHERE
ChargeDescription LIKE '%transfer%'
AND ConsumedUnit = 'GB'
GROUP BY
CAST(ChargePeriodStart AS DATE)
ORDER BY
ChargePeriodDate ASC;