IBM Apptio

When comparing a ServiceNow ticket report to Apptio there were slight count differences from month to month.  Then I recalled that ServiceNow maintains records in GMT and sure enough the records that were incorrect were due to time zone differences.  No problem! and with Apptio an easy fix. For tickets, we bring in all updated tickets in the previous month.   This way we can report on opened, touched and closed tickets.  Note:  we also bring in tasks rather than incidents as recommended by Apptio as our IT department supports a tremendous volume of non-incident related tickets; but this is an entire different discussion.  To create our transforms for opened, touched and closed tickets we create a date filter column i.e. Opened Date Filter =DateFormat(opened_at,"MMM-yy","PST").  To use the Date Filter, Apptio only accepts certain formats.   So we convert the opened_at date format to one that is accepted by the Apptio Date filter.  To resolve the timezone issue simply enter your timezone in the final argument.  Finally, set the Date Filter = Row filter (Start)