12-09-2016 09:48 AM
This report shows the results of the UK General Election from 2015 in a number of different ways.
Page 2 shows the breakdown of seats won by party. You can filter this by country (England, Wales, Scotland and Northern Ireland), which party came second in each seat, and also whether the result was a Gain (ie the winning party did not previously hold the seat) or a Hold (ie the winning party had held the seat before the election).
Page 3 shows the number of votes won broken down by party. Again you can filter by country, and you can also filter by multiple consistuencies and parties too. The latter two filters use the Smart Filter custom visual from SQLBI.
Pages 4-7 show the results for constituencies in England, Wales, Scotland and Northern Ireland. The map (built using the Shape Map visual) shows the constituencies in each country coloured according to the winning party, and you can select a constituency to see the votes cast for each candidate in that constituency. You can also zoom in and out on the map and filter using the slicers on the right-hand side.
Page 8 shows each constituency sorted by majority (the number of votes the winning party was in front of the second-place party). Again, clicking on a constituency in the chart will show the breakdown of votes cast in that constituency. In the slicers on the right-hand side is an option to filter the constituencies so you only see those where the majority was less than a certain number.