Icon

Challenge 11 - Mean Time to Close a Ticket - Solution(2)

Challenge 11 - Mean Time to Close a Ticket - Solution

Your support team would like to get some insight into the quality of their service and they ask you to analyze their support data. As a first step, they would like to find out how the time to answer a support ticket is distributed, and what the mean of this distribution is. Help your support team by using the dataset included in this challenge to (1) plot this time distribution as a histogram, and to (2) calculate its mean.

Challenge 11: Mean Time to Close a TicketYour support team would like to get some insight into the quality of their service and they ask you to analyze their support data. As a first step, they would like to find out how the time to answer a support ticket is distributed, and what the mean of this distribution is. Help your support team by using the dataset included in this challenge to (1) plot this time distribution as a histogram, and to (2) calculate its mean.
Top: Open TicketsBottom: Closed Tickets
Row Splitter
Mean time to close a ticket
Math Formula
Convert Creation andClosed date to a time cell
String to Date&Time
Calculate difference betweencreation and close date
Date&Time Difference
Read Ticket Data
Table Reader
Distribution oftime to close a ticket
Histogram (JavaScript)

Nodes

Extensions

Links