Is there a way to create a custom time parameter in Apptio?   I am attempting to create / modify the Month (Yr) to show 13 months of data instead of 12.

For example, choosing a custom time picker of Month (-13,0) would generate a report that shows: December to December data.

@Oliver Smith, @Thomas Bognar; @Julie Batty; @Jenny Franklin

Hey guys,

Have you tried to do anything like this?  I know you've done some cool things with reports.  If so, could you point Tim in the right direction?  If not, no worries.... I'll see if I can test it myself or find an internal resource.  Just thought one of you may have already tackled this one.

Deb

I've only messed with modifying the time range like that on trend charts, but never with a picker. 

Sorry I'm not of more help with this one!   Maybe @Chris Davidson knows?

You can create 13 calculated columns in your report using TimePeriod() formula. Downside of using calculated column is the column name is not dynamic. But you can group the column and use html code on group name to display the months. We are using r11, not too sure about r12.

As @Alex Ng mentioned above, that is also in my opinion the only way this could work. The problem with the "Apptio Date Perspective" is that you can only use them in 'columns'-section of the Ad Hoc Query Configurator (which made self-created columns for another month impossible).

So you would have to create 13 columns with the formulas:

=TimePeriode(metric, -12)

=TimePeriode(metric, -11)

...

=TimePeriode(metric, -1)

='metric'

to get the last 13 months in your report. You could also add them in a column picker.

I kept discovering that it makes adding columns impossible, but you can remove 'Months' from columns, add any calculated ones you need, then re-add months and it should work. Just an annoying problem

You are absolutely right, Oli. And yes, it's annoying

It seems I didn't described it right  I meant that it isn't possible to add a column which is not 'affected' if you pull in the months perspective. So it isn't possible to have the 12 months with the time perspective and one additional 13th column. If you remove the months, add the column and then add the months again, the additional column would be also in very month.

I'm not sure I can help much as we just use Months (-12,0) on our reports to show graphs that run 13 Months (as Apptio doesn't count the month you are in, you just need to select 12 previous months).

If this is what you want but just didn't know how to do it, add Months (Yr) from the time perspective to the Axis box. Then right click and choose Range, then put 12 in the Past Range box that pops up and 0 in the Future Range box, hit OK and you should be good to go.

It's a pain to do every time you want a 13 month view, but I'm not sure there is a way to have this as the default.

Thanks for all of your help folks! 

Found the solution:  If you’re looking to do it in a column picker, then you’d just add the Months (Yr) value from the Time Perspective, right click on it, and put in 13 for past range and 0 for future.   Similar to what @Jenny Franklin displayed above.

Great resource and helpful team here!