Cognos combination graphs

[ricky]

Hi,

There is a graph that I am working on which I need to plot the seconds converted in HH:MM:SS format on the y axis and date on the x- axis. So if I have 600 send on 5-apr and 1200 seconds on 6-Apr, they should plotted as 00:10:00 and 00:20:00 on 5 and 6 respectively. I am able to get the format right by using a combination of floor and varchar functions. However, when I try plotting the HH:MM:SS format on the graph I get the 0 on the histogram for all the dates. I tried using seconds alone and the graph comes up fine. This may because the HH:MM:SS is in a varchar format. So I tried casting the seconds using CAST( <seconds>, INTERVAL SECOND) which converts the seconds to a time format that I can covert using the properties. I used this on a list and it works fine. When I try to plot these values in a graph by changing it's data format (Time Interval) the result is the same. I still get 0's.

I am using Cognos 10.2.1 and creating the graph in report studio and the backend is SQL server. Been trying this since last 2 days with no luck  :(. will appreciate the help here.
:)
I have attached the screenshot for your reference.

Regards,
Ricky

[ricky]

Uploading the attachment