You guys can do that, but you need to write some code to filter this data, so a little knowledge of PHP and WP hook is necessary..
Take a look at this link:
https://github.com/madpixelslabs/visualizer/wiki/How-can-I-populate-chart-series-and-data-dynamically%3F#custom-filters
If you guys have any doubt, maybe I can help. I did a “custom filter” some days ago.
jeethghambole,
When you retrieve data from MySQL, type are always strings. So you need to convert your data type for date and number.