Dynamic Web Charts: Display 12 months

How can I add make a chart display dynamic data by month but with 12 months showing?

If I group my data by month now I get only the data that exist in my table but I would like the data to be shown specifically by the current year and all 12 months displaying even if there is no data.

I am using a time-stamp to mark my records.


Thanks

Hello theorytl401135, in order to do this you would need to do some hand code, go to the folder where the data parsers are of the charts that if you have the new version would be

domain/webassist/open_flash_charts/

Open in dreamweaver your data file something like:

chartname_data#.php where # is the number of the file and chartname_ is the name of your chart.
look for the recordset and add a where clause

example:

add this to the where you will add

WHERE DateField >= '(DATE_SUB(NOW(), INTERVAL 1 YEAR))' AND DateField <= 'NOW()'

this will get the todays date and only show the last 12 month

another more complete example, this is how it comes out directly from the wizard

$query_WADWCTable = "SELECT CONCAT( LEFT(MONTHNAME(dateField), 3), ' ', YEAR(dateField)) AS XLABEL, COUNT(idUsers) AS YVALUE 
FROM TABLENAME 
GROUP BY CONCAT( LEFT(MONTHNAME(dateField), 3), ' ', YEAR(dateField)), YEAR(dateField), MONTH(dateField) 
ORDER BY YEAR(dateField), MONTH(dateField) ASC";

so after the wizard finish i just add the where clause to the query

$query_WADWCTable = "SELECT CONCAT( LEFT(MONTHNAME(dateField), 3), ' ', YEAR(dateField)) AS XLABEL, COUNT(idUsers) AS YVALUE 
FROM TABLENAME
WHERE  dateField>= '(DATE_SUB(NOW(), INTERVAL 1 YEAR))' AND dateField<= 'NOW()' 
GROUP BY CONCAT( LEFT(MONTHNAME(dateField), 3), ' ', YEAR(dateField)), YEAR(dateField), MONTH(dateField) 
ORDER BY YEAR(dateField), MONTH(dateField) ASC";

so again to make it more understandable we are using a function that exist in php library's called INTERVAL

INTERVAL 1 YEAR
INTERVAL 15 DAYS
INTERVAL 4 MONTH

You can combine it any way you want, and finally we are using the NOW()

NOW() = Gets the actual date on the server

The trick of this is creating a between dates set up manually this gets it dynamically

Hope this helps lets us know

Sades