Analyze the different metered costs for a particular SKU
This query uses the Provider column. Provider is deprecated in v1.3 and will be removed in v1.4.
FOCUS Versions
v1.1
v1.2
Context
Understanding the individual metered costs of a particular SKU can help assist FinOps practitioners understand the cost breakdown of usage of a select cloud resource. Especially in cases where a SKU has a few component charges like (Usage hours, Throughput, API requests, etc)
FOCUS SQL Query
SELECT
ProviderName,
ChargePeriodStart,
ChargePeriodEnd,
SkuId,
SkuPriceId,
PricingUnit,
ListUnitPrice,
SUM(PricingQuantity) AS TotalPricingQuantity,
SUM(ListCost) AS TotalListCost,
SUM(EffectiveCost) AS TotalEffectiveCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ?
GROUP BY
ProviderName,
ChargePeriodStart,
ChargePeriodEnd,
SkuId,
SkuPriceId,
PricingUnit,
ListUnitPrice
ORDER BY
ChargePeriodStart ASC
LIMIT 100FOCUS Datasets
FOCUS Columns
Related Capabilities
Related Personas
Related KPIs
Percentage of Normalized, Queryable Data within Repository
Calculate percentage of normalized and queryable data in data warehouse, repository, or similar, vs Accounts Payable Invoice.
Percentage Resource Utilization
Measure of cloud compute resource utilization, e.g. Compute (EC2), Block Storage (EBS), or Object Storage (S3).
Percentage of Legacy Resource
Measure of the percentage of resources running on ‘modern’ types (e.g. instance types, volume type).
Auto-scaling Efficiency Rate
Measures effectiveness of an auto-scaling system.
Forecast Accuracy Rate (Spend)
This metric compares forecasted vs. actual cloud spend over a specific period (e.g., day, month, quarter).