Explore recipe: Calculating estimated cost of service

Have more questions? Submit a request

10 Comments

  • Fernando Duarte
    Comment actions Permalink

    How do I build the shown Dashboard?

    1
  • Rob Stack
    Comment actions Permalink

    Hi Fernando, most of the queries on that dashboard can be created in a similar way to the recipe in the article. For example, for "Cost of service by group", assuming a ticket costs you $8 to close, you could create a calculated metric containing the formula COUNT(Tickets)*(8).

    You'd use that as the metric, and Ticket group as the attribute.

    I'll add some more cost example recipes as soon as it's possible.

    0
  • Jon Rosenberg
    Comment actions Permalink

    When I try and copy and paste, or type, the SUM(Hourly rate)*SUM(Total time spent (hours)) formula, it gives me "Error at line -1 and column-1

    0
  • Rob Stack
    Comment actions Permalink

    Hi Jon, I've run through and test this. A few tips:

    1. Ensure you are using the Ticket Updates dataset

    2. The recipe required you to create three standard calculated metrics. You'll need to create all three, in order, for the recipe formula to work.

    3. Example showing it working here. If you continue to have problems, please let us know and I'll open a ticket to investigate.

    0
  • Jon Rosenberg
    Comment actions Permalink

    Thanks Rob, still not working for me. I have followed this to a T. I JUST installed the time tracking App, so perhaps it needs to log some information before this can work. 

    0
  • Rob Stack
    Comment actions Permalink

    Thanks for responding Jon, that could be it. I know from my own testing that it takes a while to filter through and the Total time spent (sec) metric won't exist in Explore until that happens. Please do let me know if it continues to fail and I'll help get a ticket opened :-)

    0
  • Jeremy Heath
    Comment actions Permalink

    @Jon i think there is too many brackets on the example remove the last one

     

    @Rob Im still new to this stuff, ive created the calculations.

    How do i put them together to make a report with it?

    0
  • Jon Rosenberg
    Comment actions Permalink

    Yeah, I'm getting either an error message, or a wildly inaccurate calculation. 

    0
  • Rob Stack
    Comment actions Permalink

    @Jeremy I've added a new section to the end of the article that explains how to use the calculation in a report. I hope this helps.

     

     

    0
  • Rob Stack
    Comment actions Permalink

    @Jon, I'm not sure why your report is failing. I'm going to open a ticket about this so someone can investigate the problem with you. I'll make any necessary doc updates based on their findings.

    0

Please sign in to leave a comment.

Powered by Zendesk