Area chart
You can add area charts to custom reports when you want to show the magnitude of change over time. An area chart is similar to a line chart. However, in an area chart, the area between the axis and the line is either colored or shaded.
► Learn about: Create custom reports
Create area charts
You can create area charts using the following combinations:
- Dimensions (one), Metrics (one), and Date Range settings
- Dimensions (one), Metrics (one), Date Range, and View By settings
Customize area charts
The Options tab on the left pane contains various formatting options for your visualization. To customize the appearance of your area charts, you can use the following options.
DrillFor detailed information on drill and the different modes, see Drills and Exploration Mode.
| Option | Description |
|---|---|
| Drill Mode | Select from None, Exploration Mode, or Fixed Table. |
| Edit Drill Table | Select to open drill options. This is enabled only when you select the Drill Mode as Exploration Mode or Fixed Table. |
| Filter Drill Table By | Select the measure(s) to filter the drill table with. |
| Option | Description |
|---|---|
| Show chart values | Show values on a chart. |
| Show tooltips | Show tool tip when you hover over a chart. |
| Spline | Use smooth curves instead of straight lines. |
| Legend | Show legend. |
| Legend prefix | Add text as a prefix to legend values. |
| Option | Description |
|---|---|
| Show scale | Show scale on the axis. |
| Start scale at | Specify the start value for scale. |
| End scale at | Specify the end value for scale. |
| Decimal places | Specify the number of decimal places in the scale. |
| Shorten numbers | Use short number format (for example, 1000 is displayed as 1k with this option). |
Use Cases
The following examples show how to create area charts in Apptio BI.
Cloud spend for last six months by ProviderTo create an area chart that displays the cloud spend for last six months by Provider, use the following settings.
| Setting | Value |
|---|---|
| Data Source | Costing Standard |
| Visualization type | Area chart |
| Dimensions | Provider |
| Metrics | OpEx |
| Date Range | Last 6 Months |
| View By | - |
| Compare To | - |
| Filter | None |
Sample chart
To create an area chart that displays the quarterly labor cost by Employee Type (External and Internal), use the following settings.
| Setting | Value |
|---|---|
| Data Source | Costing Standard |
| Visualization type | Area chart |
| Dimensions | Employee Type |
| Metrics | OpEx |
| Date Range | This Year-to-date |
| View By | Quarterly |
| Compare To | - |
| Filter | None |
Sample chart
To create an area chart that displays this year's OpEx by Business Unit, use the following settings..
| Setting | Value |
|---|---|
| Data Source | Costing Standard |
| Visualization type | Area chart |
| Dimensions | Business Unit |
| Metrics | OpEx |
| Date Range | This Year |
| View By | Default |
| Compare To | - |
| Filter | None |
Sample chart
