Flex Dashboard visualization

[antekai]

Yesterday i worked a little bit on this visualization open request.

You can check the work in progress at this repo
or preview this demo
(tip: drag to zoom in time-series and double-click to unzoom)

Open issues on this mini-project:

• Data input is static(no sync. with GoogleSheets) and visualization will update only if re-run the R-scripts (re-render HTML output).
• Using R-frameworks results an HTML-file that it's easy to develop but not that easy to customize to fit the available container class. It works fine with the container, but preview on local server was required (tested on local http-server /node.js).
• update documentation for easy-read/reproduce R-code.

[antekai]

I worked on another solution for similar visualization using jQuery+plotly.js
You can preview demo or check the source

Pros

• Dynamic input: JS script fetches the googlesheet data and visualize on the fly. When the googlesheet data change, the plots change.
• lightweight solution

Cons

• Googlesheet to JSON conversion is based on current googlesheet structure. Changing googlesheet column labels will break the script.