All tagged Dual Axis

Population Pyramid in Tableau - 2 Methods

Population pyramid is a histogram type of graphical representation that shows population by gender where values are stacked top to bottom from high to low or low to high values. Some analysts call it a step chart because it looks like a flight of stairs. From a broader view, it represents a triangle or a pyramid structure.

In this blog, we shall be discussing two methods of creating this chart in Tableau. The first method is a crude method which has multiple pieces assembled on a Dashboard. The second method is a more powerful one where all changes are done in the same visualization.

Deficit Analysis Chart in Tableau (Bar Chart)

Deficit/Surplus Analysis is a very important concept in the financial world. It has deep impact on a company’s growth and progress.

Though Deficit and Surplus go hand in hand, analysts in general refer to it as Deficit Analysis. The concept is very simple and straight forward. We usually have a Start Value or the Threshold and an End Value or the Actual. We are interested in finding the difference between these values.

Deficit Analysis can be used for a lot of situations. The most common are Calorie Intake and Nutrition Deficit, Revenue and Expenditure, Imports and Exports – Trade Deficit, Budget Deficit, Stock Volume – Break Value, Profit and Loss, Income and Expenses, Equity – Assets – Liabilities and list goes on.

Showing Min & Max and Start & End in Tableau – 2 Methods

End Users are very keen to understand the time trend of the business. Chronological progression in time reveals a lot about the journey. If the time series has a lot of fluctuations, it is easier to read only the crests and troughs. But some end users just want to look at the highest value (may be the best value) and lowest value (may be the weakest value). At the same time, there will be requests to show what the start value was and what the end value is. Showing all the four values – Start, High, Low and End depicts a very good journey of data.

In this example, we will show the labels for all the 4 above mentioned data points on a Time Series on Tableau. There are different ways to achieve this. In this blog, we shall discuss 2 different methods.

Dual Axis Chart in Tableau - 3 Methods

Comparison charts are very common and most important charts for any data. Tableau also can create some very special comparison charts. One such widely used and popular chart in excel and other BI tools is a Dual Axis Chart or referred to as Combo Chart (Involves the combination of 2 charts).

We focus on 2 measures where one measure is superimposed over another measure. Many of us assume that the second measure is placed above the first measure. It is not above, it is on (One behind another).

Any other comparison chart that we build in Tableau needs the same scale for comparison. But Dual Axis (The word itself is very intuitive – 2 Axes: one for each measure) allows for the use of different measures. In many cases, Dual Axis is used for Time Series.