Honolulu Budget 3

_.md

[ Launch: Honolulu Budget 3 ] 207521894ec530e805eb by axelson
[ Launch: Honolulu Budget 2 ] 393c6689f7606a0c99f0 by bentut
[ Launch: D3 Basics ] 8e0e8350a766a79d97fa by axelson
[ Launch: Jason Test ] 8da7744ab1eb9456929f by axelson
[ Launch: test ] 4653053 by enjalot
[ Launch: test ] 4652017 by enjalot
[ Launch: test ] 4582399 by enjalot

budget.csv

config.json

{"description":"Honolulu Budget 3","endpoint":"","display":"svg","public":true,"require":[{"name":"d3","url":"http://d3js.org/d3.v3.min.js"}],"fileconfigs":{"inlet.js":{"default":true,"vim":false,"emacs":false,"fontSize":12},"_.md":{"default":true,"vim":false,"emacs":false,"fontSize":12},"config.json":{"default":true,"vim":false,"emacs":false,"fontSize":12},"budget.csv":{"default":true,"vim":false,"emacs":false,"fontSize":12}},"play":false,"loop":false,"restart":false,"autoinit":true,"pause":true,"loop_type":"period","bv":false,"nclones":15,"clone_opacity":0.4,"duration":3000,"ease":"linear","dt":0.01,"tab":"edit","display_percent":0.7,"thumbnail":"http://i.imgur.com/coKUQxI.png","fullscreen":false,"ajax-caching":true}

inlet.js

var data = tributary.budget;
console.log("start");
tributary.trace = true;
var margin = {top: 23, right: 20, bottom: 123, left: 74},
    width = 1178 - margin.left - margin.right,
    height = 655 - margin.top - margin.bottom;

var x = d3.scale.linear().range([ 0, height])
var y = d3.scale.log()
    .base(Math.E)
    .domain([Math.exp(0), Math.exp(9)])
    .range([height, 0]);
//var y = d3.scale.linear().range([height, 0]);

var color = d3.scale.ordinal()
    .range(["#98abc5", "#8a89a6", "#7b6888", "#6b486b", "#a05d56", "#d0743c", "#ff8c00"]);

var xAxis = d3.svg.axis()
    .scale(x)
    .orient("bottom")
    .tickFormat(d3.format("$.2s"));

var yAxis = d3.svg.axis()
    .scale(y)
    .orient("left")
    .tickFormat(d3.format("$.2s"));


var svg = d3.select("svg")
    .attr("width", width + margin.left + margin.right)
    .attr("height", height + margin.top + margin.bottom)
  .append("g")
    .attr("transform", "translate(" + margin.left + "," + margin.top + ")");

function get_division(d) { return d['Department Name']; }

var divisions = d3.nest()
	.key(get_division)
	.key(function(d) { return d['Object Code Name']; })
	.rollup(function(leaves) {
	  return {amount: d3.sum(leaves, function(d) { return d['FY 2011 Actual'] }) }
	})
	.entries(data);


var max_y_val = d3.max(divisions, function(d) {
  return d3.max(d.values, function(d2) { return d2.values.amount; });
});
var min_y_val = d3.max(divisions, function(d) {
  return d3.min(d.values, function(d2) { return d2.values.amount; });
});
var max_x_val = d3.max(divisions, function(d) {
  return d3.max(d.values, function(d2) { return d2.values.amount; });
});
//debugger;
//max_y_val = 10000000
//max_y_val = 71944965401
var max_x_val = 17802708
// Possible improvement: read this from the data
var divisions_list = ["Holiday Overtime Pay", "Non-Holiday Overtime Pay", "Regular Pay"];

  y.domain([240205.72, max_y_val]);
  //y.domain([1, 8103.0839275753815]);
  //y.range([0, max_y_val]);
  x.domain([0, max_x_val]);

  x_axis = svg.append("g")
      .attr("class", "x axis")
      .attr("transform", "translate(0," + height + ")")
      .call(xAxis)
 
  x_axis
        .append("text")
        .attr("x",height)
        .attr("text-anchor","end")
        .attr("dy", -10)
        .text("Overtime Pay")
  x_axis
      // Rotate x-axis label
      .selectAll("text")
        .style("text-anchor", "start")
        .attr("dx", ".8em")
        .attr("dy", ".15em")
        .attr("transform", "rotate(65)");

  svg.append("g")
      .attr("class", "y axis")
      .call(yAxis)
    .append("text")
      .attr("transform", "rotate(-90)")
      .attr("y", 6)
      .attr("dy", ".71em")
      .style("text-anchor", "end")
      .text("Pay");

svg.selectAll("path").attr("fill","none").attr("stroke","#CCC")
svg.selectAll("line").attr("fill","none").attr("stroke","#CCC")
svg.selectAll("text").attr("fill","#828282")

svg.append("text").attr("class", "readout").attr("x", 200).attr("y",50)

  var division = svg.selectAll(".division")
      .data(divisions)
    .enter().append("g")
      .attr("class", "g")

division.append("circle")
	.attr("r",11.04)
	.attr("fill-opacity", 0.3)
	.on("mouseover", function(d) { 
      console.log(d)
      d3.select(this).attr("fill","red")
      d3.select("text.readout").text(d.key)
    })
    .on("mouseout", function(d) {
            d3.select(this).attr("fill","black")
          d3.select("text.readout").text("")
    })
	.attr("cx", function(d) {
      var overtime = d.values.filter(function(d2) { return d2.key !== "Regular Pay"; });
      var sum = d3.sum(overtime, function(d2) { return d2.values.amount; });
      console.log("sum is " + sum + " scaled is " + x(sum));
      return x(sum);
    })
	.attr("cy", function(d) {
      var reg_pay = d.values.filter(function(d2) { return d2.key === "Regular Pay"; })[0];
      return y(reg_pay.values.amount)
    })