How do I confirm the amount of coverage for a specific tag for a provider

Source: FOCUS 1.0 sample
Result rows: 1
Status: Runs on sample
Execution: PrecomputedRead-only
Result snapshot (UTC): 2026-10-11

Share of a provider's positive effective cost carried by rows that have the chosen tag key. Returned as a 0-1 ratio (the source multiplies by 100). Default: the 'application' tag on AWS, which covers about 96% of AWS effective cost.

Tag keyCharge period startCharge period end beforeProvider

Tag coverage of effective cost

96.09%

Tagged ratio

Query results
Tagged ratio	Tagged effective cost	Total effective cost
96.09%	$1,435.00	$1,493.32

1 row. Scroll inside the table to see more.

Default parameters use the precomputed result, generated as the read-only focus_reader role.

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select sum(case when tags -> $1::text is not null then effective_cost else 0 end) / nullif(sum(effective_cost), 0) as tagged_ratio,
       sum(case when tags -> $1::text is not null then effective_cost else 0 end) as tagged_effective_cost,
       sum(effective_cost) as total_effective_cost
from focus.cost_and_usage
where charge_period_start >= $2::timestamptz
  and charge_period_end < $3::timestamptz
  and effective_cost > 0
  and provider_name = $4::text

Parameters: $1 = tag_key, $2 = period_start, $3 = period_end, $4 = provider_name

Original FOCUS SQL

SELECT 
    SUM(CASE 
        WHEN JSON_CONTAINS_PATH(tags, 'one', '$.?') 
        THEN EffectiveCost 
        ELSE 0 
    END) / SUM(EffectiveCost) * 100 AS TaggedPercentage
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
     AND EffectiveCost > 0
     AND ProviderName = ?

Tagged ratio

Tagged effective cost

Total effective cost

96.09%

$1,435.00

$1,493.32

select sum(case when tags -> $1::text is not null then effective_cost else 0 end) / nullif(sum(effective_cost), 0) as tagged_ratio, sum(case when tags -> $1::text is not null then effective_cost else 0 end) as tagged_effective_cost, sum(effective_cost) as total_effective_cost from focus.cost_and_usage where charge_period_start >= $2::timestamptz and charge_period_end < $3::timestamptz and effective_cost > 0 and provider_name = $4::text

SELECT SUM(CASE WHEN JSON_CONTAINS_PATH(tags, 'one', '$.?') THEN EffectiveCost ELSE 0 END) / SUM(EffectiveCost) * 100 AS TaggedPercentage FROM focus_data_table WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ? AND EffectiveCost > 0 AND ProviderName = ?