I have some data that is stored as a number of seconds that an agent spends on the telephone (stupid I know but I didn't create the database... it would be better as a timestamp). I created a formula that would convert these value into a time variable (eg 2:23:42). I now want to chart this data again the days of the week so that it shows how much the agent was on the phone for each day of the week. However I am not able to use the data from the function formatted as a proper time. I can use the initial data as the number of seconds but when i format the chart values they don't come out correctly. For example 20000 seconds becomes 2:00:00 which is obviously wrong. Is there anything I can do?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using Time in Charts
- Thread starter Rhaegar
- Start date
Here's an idea to get you started (you'll have to work out the details).
Set up another formula field. This formula should be the talktime/86400. 86400 is the number of seconds in a day. This formula will result in a decimal figure for the time spent talking based on 24 hours.
You can then select this formula field for charting (show vaules). Then you will have to adjust the number format of the y-axis. Depending on which version you use, this is done slightly differently. I would suggest you change the number format on the y-axis to "24hh:mm". I use version 7 and that is what the format is.
Good luck!
Set up another formula field. This formula should be the talktime/86400. 86400 is the number of seconds in a day. This formula will result in a decimal figure for the time spent talking based on 24 hours.
You can then select this formula field for charting (show vaules). Then you will have to adjust the number format of the y-axis. Depending on which version you use, this is done slightly differently. I would suggest you change the number format on the y-axis to "24hh:mm". I use version 7 and that is what the format is.
Good luck!
- Thread starter
- #3
Ok so I set up the formula to be the number of seconds of talk time / 86400 to get a decimal figure representing a fraction of 24 hours (for example 0.2). However no matter what format I select for the chart it directly converts it to time. For example 2.0 becomes 0:00:02 while 0.2 becomes 0:00:00!!!! I've tried all of the format options. There are three: 13:30, 1:30:22 PM, and 13:30:22.
What am I doing wrong here?
What am I doing wrong here?
Perhaps I'm not quite understanding what you are looking for. When I use "24hh:mm" (which I think is the same as your "13:30"
, I end up with numbers such as 00:24 when the decimal is 0.017; that means the agent talked for 24 minutes.
Maybe someone else has some ideas?
, I end up with numbers such as 00:24 when the decimal is 0.017; that means the agent talked for 24 minutes.Maybe someone else has some ideas?
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question