I know this is a Reporting 1 Question, but If the spark-line I added does not display at first, what should I do? FYI, The date picker is not on the first month.

If it shows up eventually (but not right away), then it's working--and it will be pre-calculated on your STG and PRD environments, so end users won't have to wait to see the sparkline show up.

But if it's not showing up at all, try reducing the number of months of the trend (e.g., from 12 to 6 to 3).

Is the sparkline trend of a metric (e.g. Cost, Budget)?

Or is it a non-metric value trend added via custom table column formula (e.g. Trend = Sparkline(6, 0, Amount) )?

If the latter, then you may need to adjust the table grouping settings to make sure Apptio is able to determine unique rows trended over time.

Okay so follow up question, How do I reduce the number of months of the trend? The spark-line is a trend of a metric.

Sounds like you may have created the sparkline by right-clicking the metric name (in Values section of ad hoc query configuration window), then Value Field Settings > Sparkline Trend. If that's the case, it defaults to a 6 month lookback.

You could try the other method instead: inserting a custom formula column, e.g.  Trend = Sparkline(3, 0, Cost)

The second option worked! Thanks Chris!

At first, I selected the Cost column > Formula tab > drop down on Dates > selected Spark-line Trend...