BIS Derivative Data using Mike Bostock's stacked to multiple bar

BIS Derivative Data

Explore Using Mike Bostock's Stacked to Multiple Bar Example

To make this work, I had to change up the data transformation. Also, I changed the stack to use the entire height. Thanks to Jason Davies eyedropper I was able to match the colors used in the original BIS publication.

Data Source

BIS OTC Derivatives statistics

forked from timelyportfolio's block: BIS Derivative Data using Mike Bostock's stacked to multiple bar

<!DOCTYPE html>
<meta charset="utf-8">
<style>

body {
  font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;
  margin: auto;
  position: relative;
  width: 960px;
}

text {
  font: 10px sans-serif;
}

.axis path {
  display: none;
}

.axis line {
  fill: none;
  stroke: #000;
  shape-rendering: crispEdges;
}

.group-label {
  font-weight: bold;
  text-anchor: end;
}

form {
  position: absolute;
  right: 10px;
  top: 10px;
}

</style>
<script src="https://d3js.org/d3.v3.min.js"></script>
<body>
  <h1>BIS Derivative Data d3 Stacked to Multiple</h1>
<form>
  <label><input type="radio" name="mode" value="multiples" checked> Multiples</label>
  <label><input type="radio" name="mode" value="stacked"> Stacked</label>
</form>
<script>

var parseDate = d3.time.format("%b.%y").parse,
      formatYear = d3.format("02d"),
      formatDate = function (d) { return "Q" + ((d.getMonth() / 3 | 0) + 1) + formatYear(d.getFullYear() % 100); };

var margin = { top: 10, right: 20, bottom: 20, left: 60 },
      width = 960 - margin.left - margin.right,
      height = 500 - margin.top - margin.bottom;

var y0 = d3.scale.ordinal()
      .rangeRoundBands([height, 0], .2);

var y1 = d3.scale.linear();

var y2 = d3.scale.linear();

var x = d3.scale.ordinal()
      .rangeRoundBands([0, width], .1, 0);

var xAxis = d3.svg.axis()
      .scale(x)
      .orient("bottom")
      .tickFormat(formatDate);

var color = d3.scale.ordinal()

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

d3.csv("data.csv", function (error, data) {

var dataByGroup = d3.nest().key(function (d) { return d.Instrument }).entries(data);

stack(dataByGroup);
    x.domain(dataByGroup[0].values.map(function (d) { return d.date; }));
    y0.domain(dataByGroup.map(function (d, i) { return d.key; }));
    y1.domain([0, maxval]).range([y0.rangeBand(), 0]);
    y2.domain([0, maxval]).range([0, height - 200]);
      
    //match colors to BIS colors used in pdf
    //made easy using Jason Davies eyedropper https://www.jasondavies.com/eyedropper/
    color
      .domain(y0.domain)
      .range(["#929993","#c28191","#6cade1","#ffec72","#828fc6","#e3c291"]);

var group = svg.selectAll(".group")
        .data(dataByGroup)
      .enter().append("g")
        .attr("class", "group")
        .attr("transform", function (d) { return "translate(0," + y0(d.key) + ")"; });

group.selectAll("rect")
        .data(function (d) { return d.values; })
      .enter().append("rect")
        .style("fill", function (d) { return color(d.group); })
        .attr("x", function (d) { return x(d.date); })
        .attr("y", function (d) { return y1(d.value); })
        .attr("width", x.rangeBand())
        .attr("height", function (d) { return y0.rangeBand() - y1(d.value); });

group.append("text")
        .attr("class", "group-label")
        .attr("x", width)
        .attr("y", function (d) { return y1(d.values[0].value / 2); })
        .attr("dy", ".35em")
        .text(function (d) { return d.key; });

group.filter(function (d, i) { return !i; }).append("g")
        .attr("class", "x axis")
        .attr("transform", "translate(0," + y0.rangeBand() + ")")
        .call(xAxis);

d3.selectAll("input").on("change", change);

var timeout = setTimeout(function () {
      d3.select("input[value=\"stacked\"]").property("checked", true).each(change);
    }, 2000);

function change() {
      clearTimeout(timeout);
      if (this.value === "multiples") transitionMultiples();
      else transitionStacked();
    }

function transitionStacked() {
      var t = svg.transition().duration(750),
          g = t.selectAll(".group").attr("transform", "translate(0," + y0(y0.domain()[0]) + ")");
      g.selectAll("rect")
          .attr("height", function (d) { return y2(d.value); })
          .attr("y", function (d) { return y2(-d.value - d.valueOffset); });

g.select(".group-label")
        .attr("y", function (d) {
          return y2(-(d.values[d.values.length - 1].value / 2 + d.values[d.values.length - 1].valueOffset));
        })
    }
  });

</script>
</body>

https://d3js.org/d3.v3.min.js