clip

You didn't mistunderstand the purpose (However it's not an explicit goal of FnordMetric to substitute chart.io) Here is an example that connects to a MySQL database on localhost: https://github.com/paulasmuth/fnordmetric/blob/master/fnordm... Note that the IMPORT statement might be a bit misleading. The IMPORT statement only creates a "virtual table", it doesn't actually copy any data. As much of the query as possible is pushed down into MySQL/the external data source and the charts will be generated from the query result that is returned by the external data source.

It's actually fairly straightforward, you can check out the code here: https://github.com/paulasmuth/fnordmetric/tree/master/fnordm...

Yes, you can use FnordMetric to create charts from data in your existing database. Have a look at this documentation page: http://fnordmetric.io/documentation/chartsql/external_data_s... Here is a simple example for a query that uses an external MySQL database: https://github.com/paulasmuth/fnordmetric/blob/master/fnordm... Currently we only support CSV and MySQL as external data sources, but a postgres plugin is on it's way.

Here is a working example: https://github.com/paulasmuth/fnordmetric/blob/master/fnordm... And a few bits of documentation here http://fnordmetric.io/documentation/chartsql/external_data_s...

Well you could build one quick with fnordmetric https://github.com/paulasmuth/fnordmetric In fact looking at the screenshots of reportr it looks very like fnordmetric as well.

I really like that one. Now if someone could fix this issue we could even deploy it on heroku again: https://github.com/paulasmuth/fnordmetric/issues/90

Project on Github: https://github.com/paulasmuth/fnordmetric

We've gotten a lot of mileage out of fnordmetric: https://github.com/paulasmuth/fnordmetric

Please always include a link: https://github.com/paulasmuth/fnordmetric

Have you looked at FnordMetric - https://github.com/paulasmuth/fnordmetric and if so, why did you discount it as it's one I'm looking at integrating into a new site

Looks pretty awesome, sprung up after the extremely popular fnordmetric (https://github.com/paulasmuth/fnordmetric)