Get the Total Time

Follow

Master Yoda

February 03, 2020 16:18

Hi guys. I need some help. 

I want to get the Total Time of every agent  per day. For example, in the cube I have a table that has a column for timestamp.

Agent          Timestamp
A                  12/02/2019 06:11:01 AM
A                  12/02/2019 06:15:01 AM

B                  12/03/2019 07:10:00 PM

B                   12/04/ 2019 07:10:00 PM

 

So the result I want to have is the total hrs of each agent and convert it to days.
Agent A - 4mins 
Agent B - 1440 mins

and then I will convert it to days 
Agent A - 0.003 day
Agent B - 1 day

 

Is it possible ? 

0

• 

  Nathan Giusti February 04, 2020 21:57

  Hello, 

  There is no way to do this on the front end. You'll need to remodel your data to create rows with

  Agent, Task Start, Task End, Time to Complete

   

  0

  Comment actions Permalink

Please sign in to leave a comment.