I mentioned in a previous thread I might have some time this week to play with the finance data in order to maybe hook people in a bit for donations. Good news is I have, and it’s going quite well.
The code is up at https://github.com/exmosis/something-new-spending if anyone wants to have a look. There are 2 files so far:
1 PHP script to take the expenses CSV file from the SN site, and turn it into JSON output with aggregated totals by year, and by year and supplier. You can see the result at http://exmosis.net/something-new-spending/spend_as_json.php. This handles callbacks as well now, so you can request it from other domains.
1 HTML file that uses HighCharts to show the spend data for 2015 from the first script as a treemap. I figured it would also be great to list what each supplier is used for underneath. You can see the result at http://exmosis.net/something-new-spending/spend_treemap.html
Would be interested in thoughts on where this could go next. At the moment it’s only showing 2015 as a demo, and as a complete year, but it’s straightforward to show other years. Is it useful? Interesting?
In theory it could also be easily adapted to other datasets as well, but would have to try it out to know for sure…
Hope it’s thought-provoking, anyway…