7/23/2015

How to create a radar chart in Tableau

Radar chart: I can see you...

After my last blog post about The Social Progress Index, I had a question about the creation of a radar chart. I will try to answer the question clearly during this blog post. On my own, I think radar chart is intersting if you want to compare members of a dimension in function of several metrics (you can also use Parallels coordinates). For example, when you want to buy a smartphone you can compare several devices with a radar chart (metrics: battery, camera, memory...). Let's try to explain how to create this in Tableau.

Trigonometry, my best friend ever!


To create a radar chart, I have to use trigonometry formulas... You remember the circle with Pi and number and stuff like that... ?

Unit circle angles color.svg
"Unit circle angles color" by Jim.belk - Own work. Licensed under CC BY-SA 3.0 via Wikimedia Commons.

Well... It is important to use it to create axis and it depends on number of metrics you want to display. Indeed, if you want to display 5 axis (= 5 metrics) you have to use differents formulas than 6 axis chart. In my case I used a 12 axis chart so I had to use several formulas (as on the image above).
Thanks to Internet I was able to find the different formulas and create a calculation in Tableau for X axis and Y axis.

Calculation for [Xaxis]
case [Dimension]
    when "Member 1" then 0
    when "Member 2" then [Value] *(1/2)
    when "Member 3" then [Value] *(sqrt(3)/2)
    when "Member 4" then [Value]
    when "Member 4" then [Value] *(sqrt(3)/2)
    when "Member 5" then [Value] *(1/2)
    when "Member 6" then 0
    when "Member 7" then [Value] *(-1/2)
    when "Member 8" then [Value] *(-sqrt(3)/2)
    when "Member 9" then [Value] *(-1)
    when "Member 10" then [Value] *(-sqrt(3)/2)
    when "Member 11" then [Value] *(-1/2)
end

Calculation for [Yaxis]
case [Dimension]
    when "Member 1" then [Value]
    when "Member 2" then [Value]*(sqrt(3)/2)
    when "Member 3" then [Value]*(1/2)
    when "Member 4" then 0
    when "Member 5" then ([Value])*(-1/2)
    when "Member 6" then [Value]*(-sqrt(3)/2)
    when "Member 7" then [Value]*(-1)
    when "Member 8" then [Value]*(-sqrt(3)/2)
    when "Member 9" then [Value]*(-1/2)
    when "Member 10" then 0
    when "Member 11" then [Value]*(1/2)
    when "Member 12" then [Value]*(sqrt(3)/2)
end

It is very important to have the same [Value] scale for each [Dimension] members! Indeed, the 12 axis have to be the same. In my case the scale was from 0 to 100.

Build the radar to detect everything


After the creation of calculations, I had to build the chart. To do this, I just have to drag and drop the [Yaxis] on the lines shelf and the [Xaxis] on the columns shelf.


You can note that I use the aggregation Average (because Sum will returns a wrong result). Here I have only 1 point. To create the radar I have to use several dimensions (in my case, [Country] and [IndexType]). The [IndexType] allows me to draw 12 axis because this is a dimension with 12 members; [Country] allows me to draw 1 radar by country. If I want to draw the average radar chart, I can remove the [Country] field. To have several points I add [IndexType] on the Mark shelf as a Level of Detail.


After I can change the Mark to draw a polygon and add [Country] as a quick filter.


To have a beautiful radar, the last things to do are put [IndexType] as a Path to follow and Fix axis between -110 and 110 (or whatever you want to have enough space between borders and chart).


Some Formatting and "Voilà"!


To give some design to my chart, I chose to remove grid lines, Zero lines and borders, and to hide headers. Moreover, I chose to give some trnasparency and a border to my polygon in order to have a more beautiful chart.


Finally, I drew a background image to have reference axis in order to give some visual impact. Indeed, I think it is better if you know where the maximum is.


To add beautiful tooltips, it is important to put AVG([Value]) on the Mark shelf and to configure the tooltip like this:


And "Voilà"! The radar chart is done!


Thank you for the reading!

64 comments:

  1. It is the easiest and best approach to radar-charting in tableau I have come across so far. I actually managed to replicate these steps:)
    Thanks very much!

    ReplyDelete
  2. plz somebody spider chart 2 dimension and 1 cntd(customername) this is requirement. how to create spider chart send me workbook. and also what are steps and why are using this chart. my mail id. vndwh12@gmail.com

    ReplyDelete
  3. what are the calculations for a 10 axis graph?

    ReplyDelete
  4. Here's another video that explains simple radar charts - https://www.youtube.com/watch?v=mqC4saeWB0A

    ReplyDelete
  5. excellent piece of information, I had come to know about your website,i have read some posts of yours by now, and let me tell you, your site gives the best and the most interesting information. Learn here about different types of advanced charts used in Tableau.
    The advanced chart types in tableau

    ReplyDelete
  6. This comment has been removed by the author.

    ReplyDelete
  7. Your blog has given me that thing which I never expect to get from all over the websites. Nice post guys!
    Golden gate Online Training

    Hadoop Online Training

    hyperion Online Training

    ReplyDelete
  8. There are numerous payroll options made available due to the online kind of QuickBooks varying upon the need of accounting professionals and subscription plans. Quickbooks Payroll Support as well provides all possible help with the users to utilize it optimally. An individual who keeps connection with experts is able to realize about the latest updates.

    ReplyDelete
  9. QuickBooks Support Phone Number offers an extensive financial solution, where it keeps all your valuable business accounting requirements in a single place. From estimates to bank transfers, invoicing to tracking your expenses and staying in addition to bookkeeping when it comes to tax time, it really is prepared for all of it at one go. A total package to set you free from Financial accounting and back office worries any moment so that you give attention to your own expert area and yield potential development in business.

    ReplyDelete
  10. QuickBooks is the biggest selling desktop and online software across the globe. The software has transformed and helped small & medium sized companies in many ways and managed their business successfully. The smart accounting software is richly featured with productive functionalities that save time and accuracy of the work. As it is accounting software, from time to time you may have a query and will seek assistance. This is the reason why QuickBooks has opened toll free Quickbooks Support.

    ReplyDelete
  11. QuickBooks Support Phone Number now have a tendency to rank our customers over something and therefore we try to offer you a swish accounting and management expertise. you’ll additionally visit our web site to induce to understand additional concerning our code and its upgrades. you’ll scan in-depth articles concerning most of the errors and also how you can resolve them.

    ReplyDelete
  12. Is made from a lovely bunch of accounting versions, viz., QuickBooks Customer Support Number, QuickBooks Premier, QuickBooks Enterprise, QuickBooks POS, QuickBooks Mac, QuickBooks Windows, and QuickBooks Payroll, QuickBooks is actually a dependable accounting software that one may tailor according to your industry prerequisite.

    ReplyDelete
  13. QuickBooks Enterprise Support telephone number is assisted by a bunch this is certainly totally dependable. It is actually a favorite proven fact that QuickBooks Enterprise Tech Support Number has brought about plenty of improvement in neuro-scientific accounting.

    ReplyDelete
  14. QuickBooks Support Phone Number Usa is the one among the list of awesome package in the company world. The accounting the main many companies varies according to this package. You'll find so many fields it covers like creating invoices, managing taxes, managing payroll etc.

    ReplyDelete
  15. It offers you the facility of automated data backup and recovery. These features are really best for the introduction of an individual's business. QuickBooks Tech Support Phone Number Premier will likely to be two versions Premier and Premier Plus.

    ReplyDelete
  16. Pro, Premier, Enterprise, Point of Sale, Payroll in addition to Accountant, based upon your need. Quickbooks 2019 online customer support team is obviously willing to assist its customers via QuickBooks Technical Support Number with every possible error which they appear in terms with. There are times if the customers face problem in upgrading their software to the newer version, they generally face issue in generating reports etc. Though QuickBooks has made bookkeeping a child’s play, in addition is sold with a couple of loopholes that simply cannot be ignored.

    ReplyDelete
  17. Quickbooks Support will be the toll-free number of where our skilled, experienced and responsible team can be obtained 24*7 at your service. You will find a selection of errors that pop up in QuickBooks Payroll that are looked after by our highly knowledgeable and dedicated customer support executives. There are several regularly occurring Payroll errors of the software that may be of a little help to you.

    ReplyDelete
  18. QuickBooks is a well known accounting software that encompasses virtually every aspect of accounting, right from business-type to a number of preferable subscriptions. QuickBooks Support Phone Number team works on finding out the errors which will pop up uninvitedly and bother your projects. Their team works precisely and carefully to pull out all of the possible errors and progresses on bringing them to surface. They will have an independent research team that is focused and desperate to work tirelessly so that you can showcase their excellent technical skills in addition to to contribute in seamless flow of their customers business.

    ReplyDelete
  19. QuickBooks Payroll has emerged among the best accounting software that has had changed this is of payroll. Quickbooks Payroll Support contact number could be the team that provide you Quickbooks Support Phone Number.

    ReplyDelete
  20. Hope you recognize that how exactly to connect with QuickBooks Enterprise Support Phone Number. We have been independent alternative party support company for intuit QuickBooks, we do not have just about any link with direct QuickBooks, the employment of name Images and logos on website simply for reference purposes only.

    ReplyDelete
  21. QucikBooks Enterprise Tech Support is assisted by an organization this is certainly totally dependable. It is a favorite proven fact that QuickBooks has had about plenty of improvement in the area of accounting

    ReplyDelete
  22. QuickBooks Payroll Support Phone Number management is really an important part these days. Every organization has many employees. Employers have to manage their pay. The yearly medical benefit is really important. The employer has to allocate. But, accomplishing this manually will need the time.

    ReplyDelete
  23. Creating a set-up checklist for payment both in desktop & online versions is a vital task that needs to be shown to every QuickBooks user. Hope, you liked your internet site. If any method or technology you can not understand, if that's the case your better option is which will make call us at our QuickBooks Payroll Tech Support Number.

    ReplyDelete
  24. Now it has become easy to transfer the inventories to the different locations with the help of multiple location features of QuickBooks Phone Support Number. This feature is for a better quality of work and culture in the office. The user can totally control this version of the software.

    ReplyDelete
  25. QuickBooks has made payroll management quite definitely easier for accounting professionals.QuickBooks Payroll Tech Support so many individuals who are giving positive feedback if they process payroll either QB desktop and online options

    ReplyDelete
  26. These log files are also used as the messaging tool that enables a user to use the service of messages, Using these files users is able to recognize their data and along with that they also can identify the QuickBooks Support Phone Number errors that can arise.

    ReplyDelete
  27. QuickBooks Enterprise customer support cell phone number. We understand that your growing business needs your precious time which explains why we offer the most effective to the customers. Our technically skilled professionals are well regarded for smart technical assistance around QuickBooks Enterprise Support Contact Number

    ReplyDelete
  28. Are you currently utilising the software the very first time? You might get some technical glitch. You'll have errors also. Where do you turn? Take help from us straight away. We're going to provide full support to you personally. You can cope with the majority of the errors. We have to just coach you on something. Thoughts is broken trained, you're getting everything fine. Where can you turn when you yourself have to deal with the company’s transaction? It must be flawless. Do you think you're confident about any of it? If not, this might be basically the right time so you can get the QuickBook Tech Support Number. We have trained staff to soft your issue. Sometimes errors could also happen as a consequence of some small mistakes. Those are decimals, comma, backspace, etc. Are you go through to cope with this? Unless you, we have been here that will help you.

    ReplyDelete
  29. Creating a set-up checklist for payment both in desktop & online versions is an important task that ought to be shown to every QuickBooks user. Hope, you liked your website. If any method or technology you can not understand, in that case your better option is which will make e-mail us at our QuickBooks Payroll Tech Support platform.

    ReplyDelete
  30. All the flourishing Businesses square measure currently on QuickBook Support Phone Number because of the apprehend QuickBooks is the fact that the best once it involves accounting desires and management desires.

    ReplyDelete
  31. “Just dial our QuickBooks Payroll Support Number to inquire of about for Quickbooks Payroll customer service to get rid of payroll issues. We make use of startups to small-scale, medium-sized to multinational companies.”

    ReplyDelete
  32. HP Printhead Error: how exactly to Clean and Fix the Problem?
    HP Printer Tech Support Team Number is the leading device, which includes conquered the market through the time it is often established. As durable and reliable it is, there were instances when the user encountered the HP printhead errors.

    ReplyDelete
  33. a person can certainly project the sales associated with business. Our QuickBooks Customer Tech Support Number team will certainly supply you understand how to make a projection into the business in regards to the sales this has built in an occasion period.

    ReplyDelete
  34. QuickBooks is always a great and well-known name because of its 100% accuracy, certainty, and reliability. And as everyone knows that QuickBooks Support Phone Number has its own great features and QuickBooks scan manager is just one of the amazing attributes of QuickBooks just to maintain your all documents.

    ReplyDelete
  35. It is rather possible that one could face trouble while installing QuickBooks Pro software since this probably the most universal problem. You do not have to go any where if you encounter any difficulty in QuickBooks Installation, just e mail us at QuickBook Tech Support and experience matchless support services.

    ReplyDelete
  36. You can easily be confident; all of the errors and problems are handled by the simplest in operation. Our Intuit QuickBooks Support could possibly get to find in your drawback at once. this can be why we tend to square measure recognized for our client Support services. we have a tendency to rank our customers over something and therefore we make an effort to offer you a swish accounting and management expertise. you’ll additionally visit our web site to induce to understand additional concerning our code and its particular upgrades. you’ll scan in-depth articles concerning most of the errors and also the best way to resolve them. Rectifying errors desires in-depth information on the device as well as its intricacies. Our internet site might be a go-to supply for everything related to QuickBooks.

    ReplyDelete
  37. The principal intent behind QuickBooks Tech Support Phone Number is to provide the technical help 24*7 so as in order to avoid wasting your productivity hours. This is completely a toll-free QuickBooks client Service variety that you won’t pay any call charges. Of course, QuickBooks is one among the list of awesome package in the company world. The accounting part of the many companies varies according to this package. You'll find so many fields it covers like creating invoices, managing taxes, managing payroll etc. However exceptions are typical over, sometimes it generates the down sides and user wants QuickBooks client Service help.

    ReplyDelete
  38. QuickBooks Support users tend to be present in situations where they need to face most of the performance plus some other errors because of various causes in their computer system.

    ReplyDelete
  39. Canon Printer Support offers services related to all Canon printer issues. Our technical staff has enough experience and knowledge and ability to solve all your printer related issues on time. After knowing all your issues, the executives identify the issues and make all efforts in resolving them as soon as possible. In Canon printer customer support you will get well-trained and qualified technicians, and they will assist you by stepwise guidance in printer issues. To connect with the support team, you just need to dial the toll-free number of Canon printer customer support and get instant help from the professionals. The team can resolve your issues and have excellent knowledge about technology and printers. Canon printer support team are available round the clock and 365 days in a year, just to provide enhanced and improved services.

    ReplyDelete

  40. But, being a regular business person, focusing on professional accounting software, like QuickBooks Support Phone Number , is not always easy. Thus, users may have to face a wide range of issues and error messages while using the software.

    ReplyDelete
  41. QuickBooks Support Phone Number

    QuickBooks support phone number
    +1-888-422-3444. get you one-demand technical help for QuickBooks. QuickBooks allows a number of third-party software integration. QuickBooks software integration is one of the most useful solution offered by the software to manage the accounting tasks in a simpler and precise way.

    ReplyDelete
  42. You'll find regular updates through the federal government regarding the financial transaction. QuickBooks payroll satisfies statutory demand. You will get regular updates from the software. This will create your QuickBooks payroll software accurate. You won’t have any stress in operation. Even for small companies we operate. This technique is wonderful for a medium-sized company. You may get the most wonderful financial tool. QuickBooks Payroll Support Phone Number is present 24/7. You can actually call them anytime. The experts are thrilled to aid.

    ReplyDelete

  43. QuickBooks Payroll Tech Support Number have certified QuickBooks experts that are working 24*7 to resolve your payroll problems. So feel free to contact us at any time any place in throughout the

    ReplyDelete
  44. Quickbooks enterprise support number

    Contact Business Support for QuickBooks Enterprise 24/7 via the QuickBooks Enterprise Service Center. The QuickBooks Enterprise Support Number is available 24 hours a day, 7 days per week to fix your commercial QuickBooks problems. Get in touch with the QuickBook support staff to get QuickBooks Professional +1--833-400-1001 Licensed.

    ReplyDelete
  45. Quickbooks enterprise support

    Call QuickBooks to resolve Quickbooks issues with QuickBooks Enterprise Support +1-833-400-1001. Get in touch with the QuickBooks support team to get QuickBook Professional
    +1-833-400-1001 Licensed Agent.

    ReplyDelete
  46. The QuickBooks Support Number is available 24/7 to provide much-needed integration related support and to promptly make use of QuickBooks Premier with other Microsoft Office software packages.The Premier support is provided by technicians who are trained from time to time to meet up with any kind of queries related to integrating QuickBooks Premier with Microsoft Office related software.

    ReplyDelete
  47. Contact our most reliable support service to get resolve QB enterprise error in just a few minutes. Our Experts will also provide you QB training so you can resolve some of these QuickBooks errors by yourself. Get connected to us at toll-free QuickBooks Enterprise Support Number to seek help. Our experts are apt at providing friendly services to users. Further, what you need to reach our tech experts is to dial the toll-free QuickBooks Enterprise Support phone number.

    ReplyDelete
  48. QuickBooks Premier Tech Support Number serving an amount of users daily, quite possible you certainly will hand up or need to wait for few years to get in touch utilizing the Help Desk team . According to statics released because of the Bing & Google search insights significantly more than 50,000 people who are seraching the net to obtain the Quickbooks tech support team contact number on a daily basis and much more than 2,000 quarries pertaining to Quickbooks issues and errors .

    ReplyDelete
  49. Hey! Great work. I really appreciate your efforts. Keep it up. I’ll go ahead and bookmark your website for future updates. QuickBooks is one of the most acclaimed accounting software. You can easily install this software. You can even get live help and support at QuickBooks Helpline Number 1-855-236-7529. So, do call us at our QuickBooks Payroll Support Phone Number 1-855-236-7529 when any issue persists in your QuickBooks software.
    Read more: https://tinyurl.com/y2hwz69t

    ReplyDelete
  50. Hi! Great work. I especially liked the way you have embellished your blog with the necessary details. I just loved your work. I’ll go ahead and bookmark your website for future updates. keep it up. QuickBooks is the most trusted accounting software. You can avail immediate help and support at QuickBooks Phone Number Support 1-855-236-7529. The team at QuickBooks Support Phone Number 1-855-236-7529 has in-depth knowledge of QuickBooks software.
    Read more: http://bit.ly/2mfMOvN

    ReplyDelete
  51. Quickbooks Error 9999 as during program installation for business. Also a mistake occurs while Quickbooks is running, during windows startup or shutdown and sometimes even through the installation of the Quickbooks software windows operating system. If you would like to learn How To Fix Quickbooks Error 9999 yourself, you can continue reading this blog.

    ReplyDelete
  52. FuboTv affords quite a few channels that consist of entertainment, music, movies, news, kids, amongst others. You can additionally get global sports, journey channels, Latino, Portuguese, and Italian channels, amongst others. how to stream live on fubotv

    ReplyDelete
  53. Shop Support is the best flat-rate solution for entrepreneurs and shop owners looking to scale their businesses without the worry of hiring a team of designers and developers.
    Our Happy Client: Pure Life Bag
    About Pure Life Bag
    Locations

    ReplyDelete
  54. Very Nice Post. Such wonderful information to share with us. I would like to share it with my friends.
    Immigration Lawyer Near Me Virginia
    Personal Injury Lawyers Near Me Virginia
    Bankruptcy Attorney Near Me Virginia

    ReplyDelete
  55. This is exactly what I needed today. Thank you for sharing.
    Micropython Training In Hyderabad

    ReplyDelete
  56. it is very informative blogs for me , How to create a radar chart in Tableau

    ReplyDelete
  57. Awsome collection. You just refreshed my memory and con
    cepts..Thanks !.
    this is a good web site and also good sclinbio.com

    ReplyDelete
  58. I really liked your point about, I've been struggling with this myself, so I'll definitely be trying out your tips."
    bus rental Dubai

    ReplyDelete
  59. fantastic mind blowing idea to create such chart bus rental Dubai

    ReplyDelete
  60. It reveals how nicely you perceive this subject. Bookmarked this web page, will come back for extra articles. I found simply the information I already searched everywhere and just couldn’t come across. our listings offer a range of options for еvеry travеlеr. As you stroll through historic nеighborhoods, еnjoy еxquisitе cuisinе, and takе part in intriguing еvеnts, you can makе pricеlеss mеmoriеs.
    Browse: Especial Rental

    ReplyDelete
  61. Your article was engaging from start to finish. Well done!

    Bus Rental Sharjah

    ReplyDelete
  62. I'm thoroughly impressed by the quality and depth of your content. Your ability to tackle complex topics with such finesse is admirable. Thank you for consistently delivering top-notch articles!

    Buses Service

    ReplyDelete
  63. I want to express my gratitude for the positive energy you bring to your writing. It makes a significant difference.

    Marble in Dubai

    ReplyDelete