I am wondering if anyone has had the need to Total, lengths of time. 
I am trying to create an activity dashboard. 

One of of the measures of the dashboard is the length of time employees spend on the phone. 

The Data is being fed from a SQL data warehouse, to a data module as an integer that represents call length in seconds. (This can be changed if needed)

I am able to display the call times correctly in a cross tab and list by formatting the
data item as 'Time Interval'
then using the additional setting 'Time',
show Hrs =yes 
show Min =yes
show sec=yes
show ms=no

What I seem unable to do is use any type of visualisation or chart and display in HH:MM:SS




------------------------------
Jonathan berry
------------------------------

#CognosAnalyticswithWatson

Hey Jon,

I took a quick look and this is possible with Cognos Charts (Cognos 10.2.x style charts) I'm not sure at this time if it's possible using Visualizations. I will need to do further testing and back to you.

To get this to work with Cognos Charts see the attached screenshots

------------------------------
DENNY NAREZNY
------------------------------