Hello,
Im trying to create a simple line graph with two days worth of sales information on it. At the moment I can only create a graph with one line on it. Has any one seen any good basic instructions on how to do simple line graphs?
select first_created, hour, sum(amount) as amount from sal_sumdailyhour_arc
where (first_created = '2009-08-15 00:00:00' or first_created = '2009-08-14 00:00:00')
group by first_created, hour
This is the SQL code I'm using for my graph and i want a different line depending on the first_Created date but at the moment cant work out how to do it.
Any help would be great.
Thank you
Andy
...
Go to the complete details ...