# KPI Next To Bar

During my Corporate Tableau Training in Gurgaon , i get questions many time regarding KPI Next To Bar in Tableau . Tableau is about visualizations and that too visualizations that will make you stand apart. That means, you add little enhancers in your visualization that will make it appear different from a normally created viz; along with that it should satisfy your 80 : 20 relation(that means, in first 20 sec at the look of your viz you should come to know 80% of what your analysis is.).

So, on this ground, let’s make another viz that we will prove that we have an expertise in Tableau and we can actual make a viz that would be little different from others.

This time let’s change our dataset so that you can practice all the various examples that I have shared with you earlier on this data set also and gain some extra hands on experience. So, for this example we will use Sample Superstore Sales (excel) and in case you do not have the data set you can download it from the below link:

https://community.tableau.com/docs/DOC-1236

Step- 1: Open Tableau and connect it to Sample Superstore Sales (excel).

Tableau will ask you to use a Data interpreter, but you can skip using it. Drag Orders table to the Data source preview space.

Step-2: Drag Order Date (Dimension) and Customer Segment (Dimension) to the Worksheet.

Step- 3: Make two Calculated Field:

• Latest Year with the formula:

IF {MAX(YEAR([Order Date]))} = YEAR([Order Date])

THEN [Sales] ELSE 0 END

• Prior Year with the formula:

IF {MAX(YEAR([Order Date]))} - 1 = YEAR([Order Date])

THEN [Sales] ELSE 0 END

Bring these two Calculated field to the Viz and using your Show me button make a proper Text Table like the below:

Step- 4: Prepare a Bar Chart with Customer Segment in Rows and Latest Year in the Columns of the worksheet.

Step- 5: Put Prior Year Calculated field in Detail Shelf in the Worksheet and from the Analytics Pane add a reference line of Prior Year on per Cell.

Step-6:  Now we want to put the KPI next to the bars. For this we make 2 Calculated fields:

• YoY Growth with the formula:

SUM([Latest Year]) >= SUM([Prior Year ])

• Mark Position with the formula:

AVG(-50000)

Step- 7: Put Mark Position to Column & Dual Axis n synchronize axis.

Go to Latest Year marks card and switch it to bar. Then go to Mark Position and bring out Shape. Add YoY growth to shape & put desired shape.

There are no entries yet.

## Looking for Corporate Training ? Reach out to us at Akriti.Lal@instrovate.com

Reach out to us if you are looking for Corporate Training to Build The Next Generation Analytical Workforce with an in-depth understanding of  Exploratory Data Analysis , Data Visualisation, Data Analytics , AI First , Machine Learning & Deep Learning Training & Consulting helping them to take Data Informed Decision at each stage of the business.

We understand that At the present times , the Entire Industry is in a Tranformation stage with the Softwares  being rebuilt with Artificial Intelligence Capabilities .

We need SMART WORKFORCE for the SMART SOFTWARES to reap the maximum return .

Whatsapp at +91-9953805788 or email at - akriti.lal@instrovate.com if you would like to know more .

• Corporate Tableau Training in Gurgaon
• Corporate Data Analytics Training in Gurgaon
• Corporate Microsoft Power BI Training in Gurgaon
• Corporate Microstrategy Training in Gurgaon
• Corporate Google Data Studio Training in Gurgaon
• Corporate Python Training in Gurgaon
• Corporate Advance Analytics in R Programming Training in Gurgaon
• Corporate Machine Learning Training in Gurgaon
• Corporate Deep Learning Training in Gurgaon
• Corporate Data Visualization Training in Gurgaon

Instrovate Technologies

Noida, Gurgaon

akriti.lal@instrovate.com

Hit Your Refresh Button To Rise Higher