Hour x-axis showing 00

[prees959]

HI,

I am trying to chart the number of calls per hour on an bar chart. With the hour on the x-axis and the total calls on the y-axis. My expression to get the hour of the call is  :

time(hour(time([Hours],'hh')),'hh')

The chart is counting the number of calls correctly but for each hour it is showing '00' ..

can anyone help please?

Phil

[swuehl]

Just use

hour([Hours])

if your Hours field shows a timestamp. If not, clarify the format / content of that field.