|
User Details |
message
|
|
Mike Sayler
post date:
2010-03-08 22:55:41
|
I have a recordset query that pulls this data from a couple of tables:
lastname amount year
------------------------------------
Jones 100 2010
Jones 200 2011
Jones 300 2012
Smith 150 2010
Smith 200 2011
Smith 300 2012
I would like a bar chart graph to show the amount for each sales rep by year side by side comparison. I am having a hard time figuring out how this is done. Any help would be great! Thanks.
|
|
|
Andrei Rinciog [Extend Studio]
post date:
2010-03-09 07:09:21
|
Hello Mike,
Well, you need to have a different recordset for each sales rep to get this to work. Each recordset will get the values and years. For example, Smith's recordset will return:
150 2010
200 2011
300 2012
Then you can plot that data by using the years column as a category and the values column as series.
You have two possibilites. Either display a different chart for each sales rep like here: http://www.extendstudio.com/dynamic-web-charts-dreamweaver-fusioncharts-developer/Tutorial_Filtering_Charts_data_FusionCharts_Dreamweaver_PHP_%20vars.html
Or, you can plot all the recordsets inside one chart. This can be done manually by inserting a new series for each recordset or dynamically from code.
Tell me if you want me to help you set this up dynamically.
Regards,
Andrei
|
|
|
Mike Sayler
post date:
2010-03-09 09:32:50
|
Andrei,
Thanks for the response. I had considered your first response and may use that as an option. However, I would like to display the year over year, side-by-side chart also. Doing it manually presents a problem because of the potential number of sales reps there could be. The chart would be need to be dynamic. I would appreiciate your help.
Mike
|
|
|
Andrei Rinciog [Extend Studio]
post date:
2010-03-09 09:53:32
|
Hello Mike,
Please send me a page with the recordset on it at support at extendstudio.com. If you could add a sample from your database that would be helpful.
I will modify the page and send it back to you.
Regards,
Andrei
|
|
|
Mike Sayler
post date:
2010-03-09 10:36:23
|
Andrei,
Just emailed you a sample DB and recordset query used. Thanks!
Mike
|
|
