FushionCharts - ?

[Kasei]

Hello Guys,

It has been a while since I've been on here, but I am back and have a couple of questions.

Has anyone here every used FusionCharts? I am trying to setup one of their charts in FileMaker 9, but I have my calculation field is not working for me.

I need to calculate the total number of jobs in the database and break that down by year and month. I know I can setup a report with totals and subtotals to do this but I need all of this to happen in just two fields in list mode. I have been trying to put a calculation field that will give me the follow example.

2008

Jan 298

Feb 829

Mar 90

Apr 193

May 75

Jun 478

etc.

Can someone help me with putting together a calculating that could take the data enter into a submission date filed, get a total for each month and break it out in list form?

Your help would be greatly appreciated.