2. PHPRunner General questions
  3. Charting - Date Range
This topic is locked

Charting - Date Range

 		2/25/2008 6:04:12 PM
PHPRunner General questions
W
 wholly author

Hi,
I need to graph the following info.
x axis - weekly dates

y axis - employee sales
can this be done easly.
J
 		Jane 2/26/2008

Hi,
you can do it editing SQL query on the Edit SQL query tab.

Here is a sample:

SELECT

sum(Sales),

week(DateField) AS number_of_week,

concat(date_format(DateField,'%e %M %Y'),': ',sum(Sales))

FROM TableName

group by week(DateField)



where DateField and Sales are your actual field names, TableName is your actual table name.