Note: If you are more interested in learning concepts in an audiovisual format, we have this full article explained in the video below:
Target
- Tableau is the gold standard for business analytics and data visualization tools in the industry
- Learn how to create a double axis chart in Tableau
Introduction
La visualización de datos es un aspecto clave de cualquier profesión analyticsAnalytics refers to the process of collecting, Measure and analyze data to gain valuable insights that facilitate decision-making. In various fields, like business, Health and sport, Analytics Can Identify Patterns and Trends, Optimize processes and improve results. The use of advanced tools and statistical techniques is essential to transform data into applicable and strategic knowledge..... Communicate a data story in a simplistic way, but aesthetically pleasing and impressive. According to Vitaly Friedman, the “main objective of data visualization is to communicate information clearly and effectively through graphic means”.
And there is no better tool than Tableau to do it!! Tableau is one of the most trusted tools in the community. It has been recognized as a Leader in the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms for 8 years in a row. That is incredible!
In this article, we will see how to create the most desirable and useful dual axis charts.
Prerequisites
For article and homework, make sure you have Tableau installed on your system. I'm using Public Table, that you can download for free. The data we will use is the EE sample superstore dataset.. UU. That is widely used in the Tableau community. Here is the link to descargar the Superstore dataset (but the dataset will be available within Tableau).
New to Tableau? We have the perfect free course to get you started:
Let's get into it!
Create dual axis charts
A double axis graph is used to present the relationship between two variables. More specifically, These graphs are useful to demonstrate the relationship between two or more measurements with different amplitude and scale.. Dual axis charts help to present a lot of information in the limited space present on your dashboard and also allow you to understand the trends that, on the contrary, could have lost.
For instance, in our EE Super Store dataset. UU., We have the profit and sales measures. These two measurements have different magnitude and scale. Let's dive right into the implementation in a staggered fashion.
Here, for our viewing, We will use three Subcategory attributes of the dimensions and two measures, namely, Profit and Sales.
Abra una nueva hoja de trabajo y agregue la subcategoría del panelA panel is a group of experts that meets to discuss and analyze a specific topic. These forums are common at conferences, seminars and public debates, where participants share their knowledge and perspectives. Panels can address a variety of areas, from science to politics, and its objective is to encourage the exchange of ideas and critical reflection among the attendees.... de dimensiones al estante Columnas.
Now select Sales in the Measures panel and place them on the Row shelf under Subcategory. In the same way, seleccione la measureThe "measure" it is a fundamental concept in various disciplines, which refers to the process of quantifying characteristics or magnitudes of objects, phenomena or situations. In mathematics, Used to determine lengths, Areas and volumes, while in social sciences it can refer to the evaluation of qualitative and quantitative variables. Measurement accuracy is crucial to obtain reliable and valid results in any research or practical application.... Beneficio y colóquela junto al estante Ventas en fila. After this step, Your display will look like the picture below.
Here we have two graphs present on multiple axes. The next step is to convert these two different charts to a dual axis chart. For this, click on the triangle present in the profit pill on the row shelf.
Henceforth, will have a drop down menu, just select Dual Axis option from there.
Once you select the dual axis arm! your display changes completely. Like this
Although it has a dual axis display, are on different scales. Now it is necessary to bring both measurements to the same scale using synchronize axis. For it, right-click on any Profit or Sales axis and select Synchronize Axis from the menu. As shown in the following picture.
Here is the result of your dual axis graph with synchronized axes.
To make it more interesting, you can keep playing with him. How to change the form of Sales from Automatic to bar on the markets card or change the respective colors, adding borders.
In the same way, you can go to Profit and change its shape to a line. Your final visualization will look like this. Interesting right?
EndNote
To sum up, in this article we learn how to create a dual axis chart, put together multiple measures and visualize hidden insights deeper in the data. A Tableau is an interesting tool that allows users to apply their creativity and play with great visualizations.
In case you're interested in learning more about visualization and Tableau, I will recommend you to follow our course. Tableau for beginners.
Feel free to comment below in case you have any complaints.
