I'm working on the development of a system to track technology assets, as well as any events that occur with the systems (errors, config changes, etc). I want to create a graph (using google charts) that will show which devices have the most events. So there would be like the top 5 devices listed on the x-axis of the graph and then the bar graph would show how many events those top five have had. I'm using a MySQL database, but am not sure how to approach this query.
It's a matter of getting the data out of your database, then formatting it in the way your charting library needs it. Most of the formatting work is best done with a server side scripting language (like PHP, Perl, or ASP) not by MySQL itself.
I would start playing around with it and post back when you run into trouble. :)