How to Pivot Columns in Tableau Desktop
Connect with us:
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Ollie Linley on LinkedIn: / oliverlinley
Description:
Getting the structure of our data correct for Tableau Desktop can make a huge difference. Tableau is pretty picky about the way it wants our data to be formatted. Generally, each column should be a new dimension or measure.
But, sometimes, we run into tables of data that have a single dimension (or measure) split over multiple columns. In that case, Tableau won't be able to work with the data optimally. For instance, if we had a new column for every year in our dataset, we'd be limited to viewing each year as a single field in our worksheets. That would significantly reduce the kinds of analyses we could perform in Tableau.
So, by using Tableau's pivot function, we can move columns to rows in our data source, allowing us to ensure that each column is a new measure or a new dimension.
Resources:
•Download the Data Set here: https://data.world/ollielinley/tablea...
•How to Prepare (Structure) Data for Tableau Webinar: https://onenumber.biz/blog-1/2022/5/2...
