>Do you want to have a count or sum of the orders in the chart? A sum of the orders. I ALMOST have it with this. It's not grouping correctly tho cause I have multiple rows for one particular day showing.
<cfquery name="getsevendayorders" datasource="#VARIABLES.dsn#"> SELECT orderdate, ordertotal FROM tblOrders WHERE orderdate > #createODBCdate(Now() - 7)# ORDER BY orderdate DESC </cfquery> <cfquery name="eachdaystotals" dbtype="query"> SELECT orderdate , Sum(ordertotal) FROM getSevenDayOrders GROUP BY orderdate </cfquery> I figure once I get this, I'll use the query attribute in my cfchart. I could run some more queries I guess and plot each point, but heck, this should be able to be done. Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250542 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
