Today we are going through the entire process of creating a Likert Scale Diverging Bar in Tableau. This chart type is a very useful and beautiful visualisation because it shows a rating ordered in sequences, and the marks are orientated in opposite directions: positive/negative values, right/left. This means that it is easier to observe the differences between values and also to compare them.

The history of the Likert Scale is interesting because the first one was created by the psychologist Rensis Likert, who needed to represent ratings regarding international affairs. A type of Likert scale is also the one you have to give a rating from 1 to 5 (for example), 1 representing that you strongly disagree, and 5 that you strongly agree.

Tableau offers the possibility of creating a unique Likert Scale Diverging bar. In this #skillpill video, we will show you an example of analysing the profit ratio for the furniture, office supplies and technology from a database from the United States.

Here is the video tutorial:

… and here are the written steps:

**→ **In Tableau Desktop, connect to Superstore dataset from Tableau.

**→ **Create a calculated field called *Number of Records* – where the formula is: **‘1’.**

**→ **Create a calculated field called *Total Count* – where the formula is** Total(Sum[(Numbers of Records])).**

**→ **Create a calculated field called *Profit Ratio* – where the formula is **SUM([Profit])/SUM([Sales]).**

**→ **Create a calculated field called *Profit Ratio by Order* – where the formula is **([Profit])/([Sales]).**

**→ **Create a calculated field called *Profit Ratio Type* – where the formula is **IF [Profit Ratio by order]<0 then ‘Negative’ ELSEIF [Profit Ratio by order]<0.1 then ‘Neutral’ else ‘Positive’ END**

**→ **Create a calculated field called *Count Negative* – where the formula is** IF [Profit Ratio by order]<=0 THEN 1 else if [Profit Ratio by order]<=0.1 then 0.5 ELSE 0 END**

**→ **Create a calculated field called *Total Count Negative* – where the formula is** TOTAL(SUM([Count Negative]))**

**→ **Create a calculated field called *Gantt Start* – where the formula is** -[Total Count Negative]/[Total Count]**

**→ **Create a calculated field called *Percentage* – where the formula is** SUM([Number of Records])/[Total Count]**

**→ **Create a calculated field called *Gantt Percent* – where the formula is** PREVIOUS_VALUE([Gantt Start])+ZN(LOOKUP([Percentage],-1))**

**→ **Create a parameter called *Show Percentages* with the data type string and a list with the following values: Show Percentages and Show Profit Ratio

* → Create a calculated field called Show Profit Ratio* – where formula is

**→ **Create a calculated field called *Show Percentage* – where the formula is **IF [Show Percentages]=’ Show Percentages’ then [Percentage] END**

**→ **Create a hierarchy *Country, Category si Subcategory* – Bring Category over Country and Subcategory below Category.

**→ **Bring the Hierarchy created earlier on rows.

**→ **Bring *Gant Percent* and *Show Profit Ratio*on on columns.

**→ **For *Gant Percent*, bring *Profit Ratio Type* on colour, *Percentage* on size *and Show Percentage *on the label.

**→ **For *Gantt Percent*, we are going to select Gantt Bar.

**→ **For *Show Profit Ratio*, we are going to select Circle.

**→ **Bring the parameter *Show Percentages* –right-click and select– Show parameter.

**→ **Select right click – axis and select Dual Axis and Synchronize Axis.

**→ **Format Show Percentages and Show Profit Ratio on the labels to appear as a percentage – right-click – format – number – Percentage.

**Author: Alina Pătulea, Data Analyst @btProvider**

We hold all possible technical and sales certifications for all products: Tableau Desktop, Tableau Public, Tableau Server, Tableau Prep, Tableau Data Management.

With Tableau Software – the best data visualization platform – you can always understand your business or your job better. Using Tableau, you will take smart and strategic decisions and you will quickly understand the data flow, numbers and results it produces.

Are you interested in learning more about Tableau Software – one of the best analytics tools and implementing the solution in the entire company?** ****Contact us!**

See how Tableau works, by downloading a free trial here:

What is metadata? Metadata is structured information that describes various data sources and files, which can be managed and reused within jobs. Why is metadata used? Creating metadata is a Best Practice because it simplifies setting up connections and accessing […]

On April 18 we organized a private event btProvider & Vertica by OpenText titled “AI and Analytics”.

It was a private event dedicated to Data enthusiasts eager to explore the innovations of Analytics and Artificial Intelligence.

Pace charts are an alternative to bullet graphs that normalize progress-to-goal visualizations across KPIs, even when these KPIs have different data formats, scales, and/or seasonal trends. They are useful for providing an apples-to-apples, pace-to-goal comparison in businesses with KPIs spanning […]