Hacker Month -- Tableau Public

French Presidential election in 2012

This month, Tableau Public launch the Hacker Month which promote out of the ordinary vizzes. I chose to remake an old viz I have done 3 years ago about the Presidential election. This viz was created during the "inter-rounds weeks" and the aim was to simulate the final result: who will be the next president ?!

The main trick is about parameters. Indeed, I used parameters to allow users to simulate final result in function of the transfer of votes between candidates. Users can type a value from 0 to 100 and give a little part to abstention. This trick is used to calculate the result for France and for each county. The parameters was inserted in calculations to provide a percentage corresponding to the candidate's result. Here is an example of the calculation:

(([% Voix/Exp HOLLANDE]+[% Voix/Exp BAYROU]*([BAYROU pour HOLLANDE]/100)+
[% Voix/Exp LE PEN]*([LE PEN pour HOLLANDE]/100)+[% Voix/Exp ARTHAUD]+
[% Voix/Exp JOLY]+[% Voix/Exp MÉLENCHON]+[% Voix/Exp POUTOU])


([% Voix/Exp SARKOZY]+[% Voix/Exp BAYROU]*([BAYROU pour SARKOZY]/100)+
[% Voix/Exp LE PEN]*([LE PEN pour SARKOZY]/100)+[% Voix/Exp CHEMINADE]+
[% Voix/Exp DUPONT-AIGNAN]+[% Voix/Exp HOLLANDE]+[% Voix/Exp BAYROU]*([BAYROU pour HOLLANDE]/100)+
[% Voix/Exp LE PEN]*([LE PEN pour HOLLANDE]/100)+[% Voix/Exp ARTHAUD]+
[% Voix/Exp JOLY]+[% Voix/Exp MÉLENCHON]+[% Voix/Exp POUTOU]))*100

The first part of the calculation is the percentage for the left side candidate and the second part is the total. This calculation gives me a percentage used in a bar chart. The same method was used to create the map (the difference is that I chose voices quantity instead of percentage).
Moreover, I tried to create a map wich shows an overview of french counties in function of the political side. This map was different compared to the press. Indeed, this was not a map in function of political party and it tried to show a different view of french counties. For instance, it is not because a county chose UMP (right side) that the global trend is right side and vice-versa!

The last trick I used was to show bar charts in tooltips. This trick is really great because it allow users to know the distibution for each county. To do this a method is existing using special characters and formulas. Here is an example of calculation:

Left("██████████████████████████████████████████████████",ROUND([% Gauche carte 2nd tour]/2))

This calculation could be set in the tooltip to create a bar. In this case, the measure is relative (percentage) and divided by 2 because I used 50 special characters (and no 100 one). The result is a bar chart in the tooltip that we can customize (color, font...).

The last trick I used 3 years ago was a custom geocoding. Indeed, in 2012 counties for France was not available in Tableau Desktop. That is why I created a dataset allowing me to draw counties. If I had to remake it now, I think I will build the dataset in another way to make it easier to use.

Don't hesitate to leave a message or a note about this work.

Source: InsideAirbnb - Get the data
Thank you for the reading!


  1. It is beautiful article, In present days more opportunities on datavisualization,
    Tableau Online Training gives the best jobs

  2. thank you for offering such a nice content.it is very unique content and very helpful for learners and professionals

    Tableau Online Training in hyderabad
    Tableau Online Training

  3. thanks for your information
    For more information click here:
    hacking course in hyderabad

  4. This comment has been removed by the author.

  5. i just go through your article it’s very interesting time just pass away by reading your article

    looking for more updates. Thank you for sharing. Best Devops Training Institute

  6. We as a team of real-time industrial experience with a lot of knowledge in developing applications in python programming (7+ years) will ensure that we will deliver our best in python training in vijayawada. , and we believe that no one matches us in this context.

  7. This is a wonderful article, Given so much info in it, Thanks for sharing. CodeGnan offers courses in new technologies and makes sure students understand the flow of work from each and every perspective in a Real-Time environmen python training in vijayawada. , data scince training in vijayawada . , java training in vijayawada. ,

  8. I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post.
    AWS training in chennai | AWS training in anna nagar | AWS training in omr | AWS training in porur | AWS training in tambaram | AWS training in velachery

  9. Thanks for sharing information, excellent article, keep continue this....
    CRT online training

  10. I just loved your article on the beginners guide to starting a blog.If somebody take this blog article seriously
    in their life, he/she can earn his living by doing blogging.Thank you for this article.
    best tibco sportfire online training

  11. Hey, Nice one information

    Online IT Software Courses Training ICT South Bopal - Ahmedabad

    Institute of Computer Training - ICT Bopal