Skip to main content
New Idea

[analytics reports] Calculations between columns

  • February 9, 2022
  • 1 reply
  • 53 views

Forum|alt.badge.img

There are some built in calculated fields such as “ticket age” within the reporting system but there is at least one lacking that I would like to use-- For our customer satisfaction survey, I want to calculate the difference of time between the survey being sent out and the time they submit their response and to be able to generate an average of that result as well.

1 reply

Rostanchase1234
Community Debut
Forum|alt.badge.img+1

To calculate the time difference between when a customer satisfaction survey is sent out and when the response is submitted, you could use a time tracking tool like a contador de horas (hour counter). This would allow you to precisely measure the response time for each survey.

Here's how you could approach this using a time calculator:

  1. Record the exact time when each survey is sent out.
  2. Note the time when each response is received.
  3. Use a contador de horas to calculate the difference between these two times.
  4. Repeat this process for all survey responses.
  5. To get the average response time, sum up all the individual response times and divide by the total number of responses.

A time calculator like the one at calculadoradehorasonline.com.br can be very helpful for this task. It allows you to input start and end times and automatically calculates the duration. This would be especially useful if you're dealing with a large number of survey responses, as it can save time and reduce errors compared to manual calculations.

By using such a tool, you could quickly determine how long it takes customers to respond on average, which could provide valuable insights into customer engagement and the effectiveness of your survey process.

Would you like me to explain how you could set up a spreadsheet to automate some of this calculation process?