Building a custom Dashboard

[Scarpozzi]

I've got a project where I want to take a bunch of data points and create charts/graphs/tables into a custom HTML page and then Email that page to people.

This is basically a poor-man's dashboard. I went to Google first for this sort of thing. I was looking at Datastudio, but it's limitations are that I'd have to basically convert my data to gsheets. I put way too much time into doing that and getting no where. It would probably need to be a daily process and I'm trying to automate this. I looked at Google Charts, but am having trouble getting consistent results. Sometimes the pages load, other times not. It seems to be a mix of browser security issues and just plain java code issues.

Does anyone know of a good looking chart solution that would allow me to basically create a template, replace the values with variables...then just update the vars through find/replace. That's how dumbed down I'm going with this project. I need a few bar charts, tables, and that's it for now.

Thanks.

 

[Cogman]

Depends a lot on what you are charting. If is something like timeseries data (application metrics, etc). I'd take a serious look at just using grafana + (prometheus, graphite, etc)

https://grafana.com/

Otherwise, node + d3-node + react? would probably be the stack I'd chose.

 

[mxnerd]

https://www.chartjs.org/samples/latest/

https://www.youtube.com/results?search_query=chart.js+dashboard

https://www.sitepoint.com/15-best-javascript-charting-libraries/

 

[purbeast0]

If you are getting inconsistent results with Google Charts, then you're code is wrong. Google Charts should get the job done for what you are talking about as it seems to be very basic stuff you want. Their documentation can sometimes not be very clear (at least when I used it) but there was never any issues of consistency. It's nothing more than you give it values and it displays them in the format you want them to.

Things like d3 are probably overkill for what it sounds like you need. I've heard of chartjs but never used that before so I'm not really sure about it.

 

[Ken g6]

I just want to clarify, are you linking to a regular web page from the email, or are you trying to embed a chart in an email? HTML in email is hard. An SVG might work in some cases. (Support might be better than is shown there.)

 

[mxnerd]

Save the web page as a single file using SingleFile extension either in Chrome or Firefox then email it is another option.

https://chrome.google.com/webstore/detail/singlefile/mpiodijhokgodhhofbcjdecpffjipkle?hl=en

https://addons.mozilla.org/en-US/firefox/addon/single-file/

https://github.com/gildas-lormeau/SingleFile

It even has a CLI that you can do automation
https://github.com/gildas-lormeau/SingleFile/blob/master/cli/README.MD

Receiver can use any browser to open the file without installing the extension. Even Internet Explorer works.