Skip to main content

Tabular View Next Gen

note

Cloud Cost Optimization has a new version of Tabular View, called Tabular View Next Gen. The version of Tabular View you see depends on which version of Cloud Cost Optimization is enabled for your account. Tabular View Next Gen is available only with the upgraded Cloud Cost Optimization version.

If you see the Show FOCUS names toggle next to the Date Selector, you are using the new Tabular View Next Gen and the upgraded Cloud Cost Optimization version.

You can view the Tabular View from the following pages:

  • Tabular View page (Cloud > Cost Optimization > Tabular View)—This is the top-level tabular view and not specific to any billing center. Tabular View shows all the cloud spend ingested from the cloud provider for the last three years.

  • Billing Centers page (Cloud > Cost Optimization > Billing Centers)— Tabular View is a data table found in the Billing Centers page that gives you a granular view into your cloud costs. Tabular View only shows costs that are scoped to the specific billing center that you are viewing it from. It works at both the top organization level billing center that the user has access to, as well as all child billing centers below that. You can group and filter data, select the dates, and export the data.

Tabular View has several options to control the data shown:

  • Date Selector in Tabular View—Enables you to adjust the time range for the data displayed on the page. Click the date selector to open the picker. After the date selector is set, its configuration is saved as you navigate across other pages.

  • Show FOCUS Names—Enables you to view billing data in the FinOps Open Cost and Usage Specification (FOCUS) v1.0 format. FOCUS defines a common structure and naming convention for billing data that helps your organization better understand cost and usage patterns across cloud providers.

  • Filters in Tabular View—Enables you to specify which dimension values to show in the Tabular View and gives you a granular view into your cloud cost. To add filters, click the plus sign (+) next to Add dimension, select the check boxes next to the dimensions that you want to add, and then select the dimension values that you want to use to filter data in the Tabular View.

    FOCUS Dimensions

    You can choose from the following dimensions to filter data in the Tabular View:

    • Billing Centers

      • Billing Centers

    • FOCUS

      • Location
        • Availability Zone
        • Region ID
      • Profile
        • Bill Source
        • Billing Profile ID
        • Billing Profile Name
        • Customer Name
        • Customer Tenant ID
        • Partner Name
        • Partner Tenant ID
      • Account
        • Billing Account ID
        • Billing Account Name
        • Sub Account ID
        • Sub Account Name
      • Billing
        • Billing Currency
        • Consumed Unit
      • Charge
        • Charge Category
        • Charge Description
        • Charge Frequency
      • Commitment Discount
        • Commitment Discount Category
        • Commitment Discount ID
        • Commitment Discount Name
        • Commitment Discount Type
      • Charge Origination
        • Invoice Issuer
        • Provider
        • Publisher
      • Pricing
        • Pricing Category
        • Pricing Unit
      • Resource
        • Resource Name
        • Resource Type
      • Service
        • Service Category
        • Service Name
      • SKU
        • SKU ID
        • SKU Price ID

    • Rule-Based

      Rule-based dimensions are specific to your organization.

    • Tags

      Tags are specific to your organization. Contact Flexera Support to add new tags.

    To remove the filter selections, click the Edit Widget button and then click Remove filter selection. To delete all the dimensions that you added, click Delete all dimensions. Hover over the button icon to view the button name.

    To delete a specific dimension, click the Delete <Dimension Name> button next to the dimension name that you added. Hover over the button icon to view the button name.

    note

    To view non-FOCUS dimensions in the filter options, make sure to toggle off the Show FOCUS names option. For more information, see Filters in Tabular View.

  • Metrics in Tabular View—Enables you to view different cost and usage values such as List Cost, Billed Cost, Effective Cost, Pricing Quantity, and Consumed Quantity.

    Configure the metrics

    You can configure the following metrics in the Table View by clicking the three dots icon:

    • List Cost—The cost calculated by multiplying the List Unit Price by the corresponding Pricing Quantity.

    • Billed Cost—The actual amount that your organization is charged for cloud services, as shown on your invoice for a specific billing period. This value includes all discounts that have been applied by your cloud provider, but it does not amortize any upfront or recurring commitment purchases (such as Reserved Instances or Savings Plans) over multiple months.

    • Effective Cost—The total cost of your cloud usage after all discounts have been applied, and after any upfront or recurring commitment purchases (such as Reserved Instances or Savings Plans) have been amortized over the period they cover.

    • Pricing Quantity—The amount of usage that is multiplied by the list unit price to calculate the list cost, and is determined according to the cloud provider's pricing model.

    • Consumed Quantity—The actual amount of a resource or service used during the billing period, as measured by the cloud provider.

    You can show and hide the metrics in the Tabular View based on the spend that you want to see by clicking Show and Hide, respectively.

    note

    To view non-FOCUS metrics in the table view, make sure to toggle off the Show FOCUS names option. For more information, see Metrics in Tabular View.

  • Group By Filter in Tabular View—Enables you to pivot and sum costs based on a number of dimensions.

    Group By criteria options

    To get to the level of detail that is necessary to compare costs, you can select up to 10 criteria in the Group By function from the following options:

    • Billing Centers

      • Billing Centers

    • FOCUS

      • Location
        • Availability Zone
        • Region ID
      • Profile
        • Bill Source
        • Billing Profile ID
        • Billing Profile Name
        • Customer Name
        • Customer Tenant ID
        • Partner Name
        • Partner Tenant ID
      • Account
        • Billing Account ID
        • Billing Account Name
        • Sub Account ID
        • Sub Account Name
      • Billing
        • Billing Currency
        • Consumed Unit
      • Charge
        • Charge Category
        • Charge Description
        • Charge Frequency
      • Commitment Discount
        • Commitment Discount Category
        • Commitment Discount ID
        • Commitment Discount Name
        • Commitment Discount Type
      • Charge Origination
        • Invoice Issuer
        • Provider
        • Publisher
      • Pricing
        • Pricing Category
        • Pricing Unit
      • Resource
        • Resource Name
        • Resource Type
      • Service
        • Service Category
        • Service Name
      • SKU
        • SKU ID
        • SKU Price ID

    • Rule-Based

      Rule-based dimensions are specific to your organization.

    • Tags

      Tags are specific to your organization. Contact Flexera Support to add new tags.

    After you select the appropriate Group By criteria, the data table begins to populate with the cost from the selected criteria. The Group By column is ordered based on the criteria are selected first. You can move the Group By criteria to the left side or right side to group the data to your liking.

  • Search Box Filter in Tabular View—Enables you to scale down the data to your exact specifications. You can search the group by filter criteria by using the search box or the filter in each column. You can also sort the columns.

  • Expand/Collapse Group By Rows—Enables you to hide or show the detail rows based on the Group By criteria.

    Expand/Collapse rows

    The data table's default view shows all the rows, as defined by the Group By criteria, in an expanded state. You can click an individual row to collapse or expand that row. Also, once you add two or more Group By criteria, you can choose to collapse or expand all the rows in the data table by hovering over Group By column and clicking the menu icon. In the menu, choose Expand All Row Groups or Collapse All Row Groups to control the display of rows based on the Group By criteria.

  • Percent Change Indicators in Tabular View—Displays how a particular cost grouping is changing.

    Indicators

    The percent change arrows show trends from month to month. To display the arrows, click the three dots icon in the Table View and click Show Percent Change. This selection enables the color-coded up and down arrows to reflect the percent change from the previous month.

    ColorPercent Change
    Dark GreenThe decrease is 30% or more.
    Light GreenThe decrease is more than 5% and less than 30%.
    GrayThe increase or decrease is 5% or less.
    OrangeThe increase is more than 5% and less than 30%.
    RedThe increase is 30% or more.

  • Dimension Names in Tabular View—Enables you to see the names of the dimensions (such as Billing Account ID, Adjustment Name, Provider) in the Table View. Click the three dots icon in the Table View and select Show Dimension Names.

note

Consider the following:

  • To view cost anomalies and cost amortization options, see Cost Anomaly Detection and Cost Amortization in Tabular View.
  • Your user settings are saved in the backend and are available the next time you log in to Flexera One, whether you are using the same or a different device or browser. These settings include table column visibility, table column order, table column filter state, table column sort state, table column width, table column pinning, dashboard settings, and dashboards and tabular view widget settings.

After you decide which Tabular View data to show, you can:

  • Share the tabular view with other users
  • Export the tabular view data

Sharing the Tabular View With Other Users​

You can share a configured tabular view with other Cloud Cost Optimization users outside of Flexera One.

To share the Tabular View URL:

  1. Create a tabular view with the dimensions, date, and filter parameters.
  2. Click the copy tabular view icon (sideways “V”) next to the cost selector. The current URL is copied to the clipboard.
  3. Paste the URL into other tools such as email or chat clients to send to other users.

Exporting Tabular View Data​

After you select the appropriate criteria, such as Date Selector, Group By, and Filters, you can export the data to a .csv or .xlsx file.

To export Tabular View data:

  1. Click the Export CSV or XLSX button:

  2. Choose CSV or XLSX to set the file format and begin the download.

The exported file shows all columns and dates that were selected as part of that criteria, and the filters also apply.