All examples By author By category About

alexmacy

Full window Github gist

Past Presidents

This dashboard was made for testing a couple different visualizations. Mainly a sortable data table and a stacked single-line row charts. It displays data about U.S Presidents, their party affiliations, duration in office, etc.

Pie charts are very convenient, but are not ideal for accurately displaying data - not to mention have a steadily decreasing amount of fans, so I wanted something that would easliy display comparable percentages of a whole, while not requiring less space than is needed for a histogram.

That brought me to making a stacked row chart that falls somewhere in the middle of the two. To do this, I repurposed a bar chart, gave all the bars the same height, and adjusting their width and placement based upon their percentage of the whole. The top row chart resizes based on the time period selected, and the bars on both charts fade when either outside of the selected time period or if their party is not selected.

<!DOCTYPE html>
<html lang="en">

<head>

</head>

<body>

<div style="width:75%;float:left" id="charts-div">
    <span id="chart"><strong style="margin-left:10px">Party Representation:</strong><svg id="partyRowChart" class="chart"></svg></span>
		<br>
    <strong style="margin-left: 10px;margin-top: 10px">Presidential Timeline:</strong>
		<span id="presRowChart"></span>
	    <div id="numbers" style="margin-top: 10px;margin-left: 10px">
			<span style="float:left">Presidents entering office between <strong><span id="start-year">1789</span> </strong></span>
			<span>&nbspand <strong><span id="end-year">2016</span></strong></span>
			<span>: <strong><span id="count">44</span> of 44</strong></span>
		</div>
		<table id="table-div" class="table table-hover" style="margin-top: 20px;margin-left:10px">
			<thead>
				<tr>
					<th class='col-sm-2' id="num_col" onclick="sortList(byNumber, num_col)">Number</th>
					<th class='col-sm-4' id="pres_col" onclick="sortList(byName, pres_col)">President</th>
					<th class='col-sm-3' id="party_col" onclick="sortList(byParty, party_col)">Party</th>
					<th class='col-sm-2' id="enter_col" onclick="sortList(byNumber, enter_col)">In Office</th>
					<th class='col-sm-1' id="years_col" onclick="sortList(byYearsInOffice, years_col)">Years</th>
				</tr>	
			</thead>
			<tbody></tbody>
		</table>	
	</div>
	<div id="color-div" style="width:25%;float:right">
		<ul style="list-style-type:none;">
			<li class="checkbox"><label><input type="checkbox" onchange="checkAll(this)"><b style="color: black">Select All</b></label></li>
		</ul>
		<ul style="list-style-type:none" id="party-list">
		</ul>
	</div>

</body>

//some global variables
	var filter = [],
		listDimension,
		brush,
		width = document.getElementById('table-div').getBoundingClientRect().width,
		height = 70,
		barHeight = 40,
		sortBy = 'desc',
	    presList;

//x-axis for presRowChart & brush-slider
	var xYear = d3.scale.linear()
		.domain([1789,2017])
		.range([0,width - 20])

//define the skeletons for the charts and brush-slider
	var partyRowChart = d3.select('#partyRowChart')
		.attr('width', width - 20)
		.attr('height', barHeight)
		.attr('style', 'margin-left:10px');

var presRowSVG = d3.select('#presRowChart').append('svg')
		.attr('width', width)
		.attr('height', 90);

var presRowChart = presRowSVG.append('g')
		.attr('width', width - 20)
		.attr('height', 40)
		.attr('transform', 'translate(10,0)')

//set colors to political parties and create and ordinal scale
	var parties = ['Democratic', 'Democratic-Republican', 'Federalist', 'No-Party', 'Republican', 'Whig'],
		colorSet = ['#0f5495', '#0f750f', '#8a5724', '#757575', '#db0f0f', '#ff950e'];

var colors = d3.scale.ordinal().domain(parties).range(colorSet);
	
	//pare the dates down to just the year
	presidents.forEach(d => {
		d.took_office = +d.took_office.split("-")[0];
		d.left_office = +d.left_office.split("-")[0];
		d.years_in_office = +d.left_office - +d.took_office; 
	})

//load the crossfilter
	var cf = crossfilter(presidents);
	var byParty = cf.dimension( d => d.party);
	var byNumber = cf.dimension( d => d.number);
	var byName = cf.dimension( d => d.president);
	var byTookOffice = cf.dimension( d => d.took_office);
	var byYearsInOffice = cf.dimension( d => d.years_in_office);

//create the party list for the right side 
	d3.select('#party-list').selectAll('li')
			.data(parties)
		.enter().append('li')
			.attr('class', 'checkbox')
			.attr('id',d => d + '-box')
			.append('label')
			.html((d) =>'<input type="checkbox" id="' + d + '_Box"><b style="color:' +  colors(d) + '">' + d + '</b>')
			.on('click', d => filterByParty()  );

/////////loading visualization elements

function loadPartyBar() {

d3.select('#partyRowChart').selectAll('g').remove();

d3.select('#count').html(byParty.top(Infinity).length);

var data = byParty.group().all();
		var total = d3.sum(data, d => d.value);

var x = d3.scale.linear()
			.domain([0, total])
			.range([0, width - 20]);

var bar = partyRowChart.selectAll('g')
				.data(data)
			.enter().append('g')
                .attr('transform', (d,i) => 'translate(' + x(total - d3.sum(data.slice(i), n => n.value)) + ',0)')
        		.on("mouseover", d => tooltip.style("visibility", "visible").text(d.key))
				.on("mousemove", d => tooltip.style("top", (event.pageY-10)+"px").style("left",(event.pageX+10)+"px"))
				.on("mouseout", d => tooltip.style("visibility", "hidden"));

bar.append('rect')
			.attr('width', d => x(d.value))
			.attr('height', barHeight - 1)
			.attr('fill', d => colors(d.key))
			.classed('deselected', d => filter.indexOf(d.key) < 0 )

bar.append('text')
			.attr('x', d => x(d.value) - 3)
			.attr('y', barHeight / 2)
			.attr('dy', '.35em')
			.text( d => {if (d.value != 0) { return d.value; }})

};

function loadPresBar() {

var bar = presRowChart.selectAll('g')
				.data(byNumber.bottom(Infinity))
			.enter().append('g')
				.attr("transform", d => "translate(" + xYear(+d.took_office) + ",0)")
        		.on("mouseover", d => tooltip.style("visibility", "visible")
        								.html(d.president + " : " + d.took_office + ' - ' + d.left_office))
				.on("mousemove", d => tooltip.style("top", (event.pageY-10)+"px").style("left",(event.pageX+10)+"px"))
				.on("mouseout", d => tooltip.style("visibility", "hidden")
										.html(''));

bar.append("rect")
			.attr("height", 40)
			.attr("width", d => xYear(d.left_office) - xYear(d.took_office))
			.attr('fill', d => colors(d.party))
			.attr('id', d => 'bar_' + d.took_office)
			.attr('class', d => 'presBar ' + d.party)

presRowChart.append("g")
    			.attr("class", "x axis")
			    .attr("transform", "translate(0," + 40 + ")")
    		.call(d3.svg.axis()
				.scale(xYear)
				.orient("bottom")
				.ticks(5)
				.tickFormat(d3.format("")));

}

function loadSlider() {

brush = d3.svg.brush()
	    	.x(xYear)
	    	.extent([1829, 1901])
	    	.on('brush', d => brushed())

var brushg = presRowSVG.append("g")
	        .attr("class", "brush")
		    .attr("transform", "translate(10," + 40 + ")")
	        .call(brush);

function handlePath(d) {
	        var e = +(d == "e"),
	            x = e ? 1 : -1,
	            y = height / 3;
	        return "M" + (.5 * x) + "," + y
	            + "A6,6 0 0 " + e + " " + (6.5 * x) + "," + (y + 6)
	            + "V" + (2 * y - 6)
	            + "A6,6 0 0 " + e + " " + (.5 * x) + "," + (2 * y)
	            + "Z"
	            + "M" + (3.25 * x) + "," + (y + 8)
	            + "V" + (2 * y - 8);
			}

brushg.selectAll(".resize").append("path").attr("d", handlePath);

brushg.selectAll("rect").attr("height", 48);

brushed();

}

function loadPresList() {
		
		var listHTML = "";

presList = (sortBy == 'desc') ? listDimension.bottom(Infinity) : listDimension.top(Infinity); 
    
	    for (let i of presList) {
			listHTML +='<tr id="list-line' + i.number + '" class="' + i.party + '_row">' + 
						'<td>' + i.number + '</td>' + 
						'<td>' + i.president + '</td>' + 
						'<td>' + i.party + '</td>' + 
						'<td>' + i.took_office + ' - ' + i.left_office + '</td>' + 
						'<td>' + i.years_in_office + '</td>' + 
					'</tr>';
		};

d3.select('tbody').html(listHTML);

}

function sortList(dimensionVal, col) {

dimensionVal != listDimension ? listDimension = dimensionVal : sortBy == 'desc' ? sortBy = 'asc' : sortBy = 'desc';

loadPresList()

}

////////////////filtering functions

function brushed() {

var brushYears = brush.empty() ? [1789,2017] : brush.extent().map(Math.round)

byTookOffice.filter([brushYears[0],brushYears[1]]);

d3.select('#start-year').html(brushYears[0]);
		d3.select('#end-year').html(brushYears[1]);

filterByParty();
		
    }

function checkAll(val) {

var boxes = d3.selectAll('input')[0]; 
	
		val.checked ? boxes.forEach( d => d.checked = true) : boxes.forEach( d => d.checked = false)

filterByParty();

}

function filterByParty() {

//reset the filter
		filter = [];

for (let i of parties) {
			if (document.getElementById(i + "_Box").checked) { filter.push(i) };
		}

//if no boxes have been checked, push all the parties to the filter
		if (filter.length == 0) { filter = parties; }
		
		//filter the dimension
		byParty.filter( d => filter.indexOf(d) > -1);
		
		//change opacity of president bars based on if their party is filtered and they don't fall within the time range
		d3.select('#presRowChart').selectAll('.presBar')
			.classed('deselected', d => byTookOffice.top(Infinity).indexOf(d) < 0);
			
		loadPartyBar();
		loadPresList();

}

function loadAll() {		
	    presList = byNumber.bottom(Infinity)
	    listDimension = byNumber
		loadPartyBar();
		loadPresList();
		loadPresBar();
	}

loadAll();
	loadSlider();

var tooltip = d3.select("body")
		.append("div")
		.style("position", "absolute")
		.style("z-index", "10")
		.style("visibility", "hidden")
		.style("background-color", "black")
		.style("color", "white")
		.style("padding", "5px")
		.style("border-radius", "5px")

</script>

https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.16/d3.min.js

https://cdnjs.cloudflare.com/ajax/libs/crossfilter/1.3.12/crossfilter.min.js