THE LINUX FOUNDATION PROJECTS
FOCUS Logo
Docs navigation
On this page

    2.8 Data Granularity

    2.8.1 Description

    FOCUS supports multiple levels of cost and usage data granularity. This includes the ability to report on a daily, hourly, or other time period basis. FOCUS also supports the ability for cost and usage data to be provided for high granularity scenarios, such as down to the individual resources. It also supports high level granularity cost and usage data, such as account level, or service level charges.

    2.8.2 Directly Dependent Columns

    Resource ID Resource Name Charge Period End Charge Period Start

    2.8.3 Supporting Columns

    Billed Cost Consumed Quantity Consumed Unit Effective Cost List Cost Pricing Currency Pricing Unit

    2.8.4 Example SQL Query

    Example SQL Query

    SELECT
  ChargePeriodStart,
  ChargePeriodEnd,
  ResourceId,
  SUM(EffectiveCost)
FROM focus_data_table
Group by
  ChargePeriodStart,
  ChargePeriodEnd,
  ResourceId
    Previous Custom Columns Next Effective Cost Analysis