Sample Apptio BI visualization

Edit online

This section provides some example visualizations and the settings that create them.

OpEx spend per cost center owner bar chart

Set the following fields to these values:

  • Visualization Type - Column
  • Period - This Month
  • Compare To - Previous Period
  • Dimension - Cost Center Owner
  • Metric- OpEx
  • Sort Measure - OpEx
  • Order - Desc
  • Filter - None

Lease type per cost (total) pie chart

Set the following fields to these values:

  • Visualization Type - Pie
  • Period - This week
  • Dimension - Lease Type
  • Metric - Cost (Total)
  • Limit Results To - Top 20
  • Filter - None

Two metric KPI

Set the following fields to these values:

  • Visualization Type - KPI
  • Period - This quarter
  • Metrics - OpEx, OpEx Budget
  • Filter - None

Details of current month spend per account compared to previous month

Set the following fields to these values:

  • Visualization Type - Table
  • Period - This Month
  • Compare To - Previous Period
  • Dimensions - Cost Pool, Cost Sub Pool, Account Group, Account, Account Description
  • Metrics - OpEx, OpEx Budget, CapEx Budget
  • Sort Measure - OpEx
  • Order - Desc
  • Filter - None

Details of monthly spend per owner and cost center compared to previous year

Set the following fields to these values:

  • Visualization Type - Table
  • Period - This Month
  • Compare To - Last year
  • Dimensions - Cost Center Name, Cost Center Owner
  • Metrics - OpEx, OpEx Budget, CapEx Budget
  • Sort Measure - CapEx
  • Order - Desc
  • Filter - None

Basic trend table per month

Set the following fields to these values:

  • Visualization Type - Table
  • Period - This Year
  • View By - Monthly
  • Dimensions - Cost Pool
  • Metrics - OpEx
  • Sort Measure - Cost Pool
  • Order - Desc
  • Results - 50
  • Filter - None

Tower equals 'Compute'

Set the following fields to these values:

  • Visualization Type - Table
  • Period - This Month
  • Dimensions - IT Resource Tower Name, IT Resource Sub-Tower Name
  • Metrics - OpEx
  • Sort Measure - OpEx
  • Order - Desc
  • Results - 50
  • Filter Measure - IT Resource Tower Name
  • Filter Operator - Contains
  • Filter Value - Compute

IT Resource Tower Spend

Set the following fields to these values:

  • Visualization Type – Stacked Column Chart
  • Period - This Year to date
  • View by – Monthly
  • Dimension – IT Resource Tower Name
  • Metric - OpEx

Top 10 Applications by Spend this month

Set the following fields to these values:

  • Visualization Type - Column
  • Period - This Month
  • Dimensions - Application Name
  • Metrics - OpEx
  • Sort Measure - OpEx
  • Order - Desc
  • Results - 10

Compare spend month over month

  • Visualization Type - KPI
  • Period - This Month
  • Compare to – Previous Period
  • Dimension - Owner
  • Metric – OpEx
  • Decimal places (select the arrow next to the metric) – 2
  • Options tab
  • Comparison Arrow – Up is red, down is green
  • Shorten Metric(s) – On

Compare Planning Budget vs Costing Standard Actuals

  • Visualization Type - Overlay
  • Period - This Year
  • View by – Monthly
  • Layer #1
    • Data Source: Costing Standard
    • Metric – OpEx
  • Layer #2
    • Data Source: Planning
    • Metric – Amount