Apptio for All

Apptio for All

A place for Apptio product users to learn, connect, share and grow together.

 View Only
  • 1.  Metric for Ticket Counts?

    Posted Thu December 07, 2017 06:46 PM

    I have created a new object/allocation that integrates Service Desk tickets into our model and allocates the cost accordingly.  I have a column in the Service Desk Tickets Master Data labeled "Ticket Counts" which basically equals 1 for each ticket.  When I pull the "Ticket Count" field into my report, it works fine for the current period, however I would like to show YearToDate Ticket count in the report.  Any idea how I can achieve that?  I'm not looking to allocate the counts anywhere past the "Service Desk" object. 


    #ApptioforAll


  • 2.  Re: Metric for Ticket Counts?
    Best Answer

    Posted Mon December 11, 2017 08:46 AM

    Hi Doug,

     

    you can create a new formula column in your report:

     

     

    There you can use the YearToDate function with the syntax: =YearToDate(Data Set Name.Column Name)

     

    e.g. like this:

     

     

    Hope that helps.

     

    Regards,

    thomas


    #ApptioforAll