Explore Report: Add Calc on cost per ticket | Community
Skip to main content

Explore Report: Add Calc on cost per ticket

  • June 1, 2021
  • 2 replies
  • 0 views

Craig20

Hi All,
This should be simple but its proving difficult.
I know my cost per ticket is about $20

I'm trying to pull a Tickets created (or solved) * 20 to get a total cost over X time period.

2 replies

  • June 2, 2021

@Craig VanDeVenter It sounds like a Result Metric Calculation might work for this use case. You'll want to select the metric you'd like to calculate cost by (i.e. tickets created or solved) to your query. From there, select Result Manipulation > Result Metric Calculation and then enter COUNT(Your metric)*20 as the formula. 


Craig20
  • Author
  • June 7, 2021

@Chandra Robrock That was incredibly too easy.   <face palm>

Amazing!  Appreciate it!