Calculate unit economics

Source

FOCUS 1.0 sample

Result rows

30

Status

Runs on sample

Execution

PrecomputedRead-only

Result snapshot (UTC)

2026-10-11

Calculates daily billed cost per GB for descriptions containing the case-sensitive substring transfer; matching sample charges are in USD. The denominator retains full numeric consumption precision instead of rounding each row to two decimal places before summing.

Precomputed result

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 500

SELECT
    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;