Newbie XY bar graph expression problem

[xad]

I have a simple chart that I'm having problems with.

I have a query which returns 2 types, one of which is a long and another as a type time broken down in hourly increments.

I want to simply have the time displayed (2:00, 3:00, 4:00 etc) on the X-Axis Expression but I keep getting an error stating that the variable cannot be cast from time to Number. I tried casting it to ints but no luck.

Here is my expression list

Series Expression = Yesterday's Date (java.sql.Date)

X Value Expression = Hour (java.sql.Time)

Y Value Expression = Totalhits (java.sql.Long)

Label Expression = none.

What am I doing wrong? I simply want the each X hour to display Y hits.

 

 

[xad]

After doing some digging, I found that I needed to use the YX Bar which gives you an option to categorize by time.

[xad]

Still.. I can only use the YX bar graph when I want to use time on the X Axis? What if I wanted to do a line graph. Every other graph has category or xy datasets.