- Source
- FOCUS use-case library
- Data
- FOCUS 1.0 sample
- Status
- Runs on sample
- Mode
- Read-only
- Library snapshot (UTC)
- 2026-10-08
Loading sample results
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;