Need to chart 2 timestamps for a status time and graph the whole day
I am looking for ways to take 2 timestamps, a start, and an end timestamp, and chart them to account for a user's activity that day. I am using call center agent status times and want to have a bar chart for each agent that shows their status for the day and then plot in the calls that came in with wait time and talk time. What would be the best way to go about building this? Can I do it at the chart level or will I need to use ELT?
Here is a sample of the data I want to chart