Need help with hours in charts

[Meg00]

Hi,

So the problem I have is that I have a table with timestamps looking like this: HH:MM:SS, and I want to find a resonable easy way to just show the hours in a chart that displays how many stamps i have for each hour. The tables name is "Tid" and each stamp connects with a "contact" in another table so I want to be able to show how many "contacts" I have for each hour.

I'm sure theres an easy way and I hope theres someone out there who could help a newbie out.

[sreenivas]

Can you post the sample data

[er_mohit]

cOUNT(interval(time#(timestamp,'HH:MM:SS'),'HH'),contact)

hope it helps you

[#4]

Hi,

find the attachement, it may help you

Niranjan M