Using Pivot in Tableau 10.0

For Corporate training and Online Training contact at info@instrovate.com

During my Corporate Tableau Training in Gurgaon , i get questions many time regarding Pivot Tables.  I got good acclaim from Tableau experts on this blog . You can view it at this tableau Community Link - Tableau Pivot Link on Tableau Community 

A pivot table allows you to extract the significance from a large, detailed data set. You can pivot the data in your Microsoft Excel, text file, and Google Sheets data sources from crosstab format into columnar format to more easily perform analysis. Or, if you are not working with the types of data listed, you can use custom SQL as an alternative way to pivot your data in Tableau.

To explain pivot in tableau let’s take help of an example:

Suppose we have conducted a survey of the popularity/ preference of washing machines and the result is the excel below:

 

So, now the requirement is that we want to analyze the feedback of each washing machine on the basis of Agree, Disagree and Neutral in Tableau.

Let’s connect Tableau to the excel and move ahead with the visualization:

The above visualization is not satisfying the requirement as the visualization is showing the total number of a particular combination ( i.e the highlighted Tableau visualization is showing that there are 5 records where we have a Neutral & an agree feedback). This is definitely not what we want.

In such scenarios the need of Pivot arises. To pivot in Tableau, follow along:

Step -1

After you have established you data source connection and have got the preview of the data; click on Manage Metadata pill to get the below visualization:

 

 

Step-2

Pivot the table as below:

 

Step-3:

The pivot result will be like this:

 

The original fields in the data source are replaced with new fields called “Pivot field names” and “Pivot field values.” You can always rename the new pivot fields.

 

Step-4:

Finally, the Tableau Visualization which will state the individual feedback of the Washing Machines:











 

Few points to remember while working with Pivot:

At a glance: Working with pivots

  • The Pivot option is available from the grid and metadata grid.

  • All fields in the pivot must be from the same connection.

  • Only one pivot is allowed per data source.

  • Pivot fields can be used as the join key.

  • The Pivot option cannot be used in calculated fields.

Troubleshooting pivots

 

For Corporate training and Online Training contact at info@instrovate.com

  • Red fields in the view and fields with exclamation points in the Data pane: Because the original fields are replaced with new pivot fields, any references to the original fields in the view will no longer work. They cause fields to become red in the view or show a red exclamation point next to the field in the Data pane.

  • Null values in the grid: If all of the original fields used in the pivot are removed, for example in an extract refresh, null values display in the pivot fields.

Write a comment

Comments

  • Shubhi (Thursday, May 31 18 06:03 am EDT)

    in latest version of tableau, I could not see this pivot option on grid

Please enter the code
* Required fields

Subscribe to our mailing list

* indicates required

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

 

Address

Instrovate Technologies

Noida, Gurgaon

 

akriti.lal@instrovate.com 

Hit Your Refresh Button To Rise Higher
Print Print | Sitemap
All rights reserved @ Instrovate Technologies
GSTIN : 09AAECI6862K1Z1

Terms Of Services    Privacy Policy    Disclaimer     Refund Policy    


Call

E-mail