dashboard / Other / Tableau

Europe is burning in an election fever

2017-04-26

How can you visualize a parliamentary distribution on a half curve shape, like this?

 

 

If you are really interested in the points’ arrangement, check Rajeev Pandey’s deep technique process on how to build a sunburst-chart-tableau.

If you don’t really want to bother with the technique, just download my grid layout here: Excel

It contains 110 points instead of 100 because I wanted to create a shape without the straight lines.Every point belongs to an  X and Y coordinate and the most important data is the ’Percentage’ column. The color of the points depends on this information.

Andy Kriebel had already shared his waffle template: http://www.vizwiz.com/2017/01/tableau-tip-tuesday-how-to-create.html

My chart also uses his technique, just in a rotated waffle chart form.

  • Import the ’Shape’ datasource and your data, which contains the distribution (like the gender distribution).
  • I filtered out the unnecessary 10 points((-5) – (-1) and 101-105) in the report and then I got this:

 

  • Create a new calculated field that displays the distribution by colour.

([woman in parlament].[Rate])>=SUM([Percentage])

 

  • As the last step, just modify the visual and it is DONE 😊

Have fun!

@IvettAlexa

3 likes

Author

Ivett Kovács

I love taking datasets into beautiful and informative visualizations. Besides data, I am also very passionate about traveling, surfing, cooking and exploring the outdoors with my dog.

Comments (2)

  • March 23, 2018 by Alan

    Alan

    Thanks Ivette for sharing your technique. I tried to replicate the sum(Columns) and sum(Rows) and filtered out relevant IDs and have ID in the detail, but I do not get that nice shape you have. My Y axis is 7.5m and X axis is 7m.

    Do you know why?

    • March 28, 2018 by Ivett Kovács

      Ivett Kovács

      Hi Alan,

      could you please send me your workbook as .twbx.
      kovacsi@starschema.net

      Thanks,
      Ivett

Your email address will not be published.