Line chart
You can add line charts to custom reports when you want to display trends over a period of time.
► Learn about: Create custom reports
Create line charts
You can create line charts using the following combinations:
- Dimensions (one), Metrics (one), and Date Range settings
- Dimensions (one), Metrics (one), Date Range, and View By settings
Customize line charts
The Options tab on the left pane contains various formatting options for your visualization. To customize the appearance of your line 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 line charts in Apptio BI.
OpEx for last six months by Employee TypeTo create a line chart that displays the OpEx for last six months by Employee Type, use the following settings.
| Setting | Value |
|---|---|
| Data Source | Costing Standard |
| Visualization type | Line chart |
| Dimensions | Employee Type |
| Metrics | OpEx |
| Date Range | Last 6 Months |
| View By | - |
| Compare To | - |
| Filter | None |
Sample chart
To create a line chart that displays the YTD cloud spend by Provider, use the following settings.
| Setting | Value |
|---|---|
| Data Source | Costing Standard |
| Visualization type | Line chart |
| Dimensions | Provider |
| Metrics | OpEx |
| Date Range | This Year-to-date |
| View By | Monthly |
| Compare To | - |
| Filter | None |
Sample chart
To create a line chart that displays this year's OpEx by Business Unit, use the following settings.
| Setting | Value |
|---|---|
| Data Source | Costing Standard |
| Visualization type | Line chart |
| Dimensions | Business Unit |
| Metrics | OpEx |
| Date Range | This Year |
| View By | Default |
| Compare To | - |
| Filter | None |
Sample chart
