jms301 / pfi-explorer

MIT License
2 stars 2 forks source link

Gotta have a Dashboard #11

Open atiro opened 10 years ago

atiro commented 10 years ago

Everyone loves a dashboard!

OK, so it's now a bit of a cliche. But showing the table on the front page is a bit off-putting perhaps? Could have various stats presented on the front page with links to individual projects Most expensive PFI projects, longest repayments, biggest annual payment, etc, etc...

jms301 commented 10 years ago

Sounds good to me.

atiro commented 10 years ago

Dear James,

Sounds good to me.

Damn, I thought I'd offloaded the work onto you...

regards,

Richard

jms301 commented 10 years ago

Well I'll happily code it if you can tell me what goes on it! Do you have that D3 bubble chart code? I've switched us over to D3 now all works fine.

atiro commented 10 years ago

Code is here: http://pfi.tiro.org.uk/viz (totally stolen from demo on D3 site) using data here (I just pulled the figures out with jq): http://pfi.tiro.org.uk/viz/project_costs.json

I saw there is a dashboard setup for bootstrap, could use that ? I suppose things like num of PFI projects, total spend, total repayments, etc.

atiro commented 9 years ago

Dear James,

Well I'll happily code it if you can tell me what goes on it! Do you have that D3 bubble chart code? I've switched us over to D3 now all works fine.

Some nice dashboard templates for bootstrap here - http://keen.github.io/dashboards/

Now getting to grips with D3 to make a animated bubble graph.

regards,

Richard

jms301 commented 9 years ago

Richard,

Finally getting around to this, your code basically could go directly into the project but we/I need to work out a better way to handle the data. Having a 'charts' collection was a reasonable choice for time limited hackathoning when all charts look the same. But I guess really we should just add fields to the projects collection & build our charts from the real data.

jms301 commented 9 years ago

How did you calculate the 'size' in the http://pfi.tiro.org.uk/viz/project_costs.json linked above? Quite a few of them have a null value btw which seems wrong?

atiro commented 9 years ago

Dear James,

How did you calculate the 'size' in the http://pfi.tiro.org.uk/viz/project_costs.json linked above? Quite a few of them have a null value btw which seems wrong?

It's the capital value, which is blank in some cases (not sure why?).

Could use the sum of the annual payments instead? That's what the bubble chart uses.

regards,

Richard

jms301 commented 9 years ago

The bubble chart you linked above uses the projects_costs.json with capital value. Is there json file linking HMT_ID with the sum of the annual payments? If so I'll add it to the projects collection. Can you link me it?

Cheers, James

atiro commented 9 years ago

Dashboard of a sort in, although labels very clunky and bar graph not working currently.