tag:blogger.com,1999:blog-3178813192704651028.post145970692285162891..comments2024-03-28T17:52:37.818-04:00Comments on The Flerlage Twins: Analytics, Data Visualization, and Tableau: How to Perform Multiple Pivots in Tableau DesktopKen Flerlagehttp://www.blogger.com/profile/03698843288892226027noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-3178813192704651028.post-90427058791597195432024-02-27T10:29:04.051-05:002024-02-27T10:29:04.051-05:00YesYesKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-82749326787847999192024-02-26T16:32:16.259-05:002024-02-26T16:32:16.259-05:00Do you know if the pivot option within Desktop is ...Do you know if the pivot option within Desktop is still available in 2023.3.3? Rebeccanoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-87614491543120075492022-09-15T10:13:53.190-04:002022-09-15T10:13:53.190-04:00I'd need to see the workbook. Can you email me...I'd need to see the workbook. Can you email me? flerlagekr@gmail.comKen Flerlagenoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-64041933896152082632022-09-15T04:26:51.066-04:002022-09-15T04:26:51.066-04:00Thanks for the tip.
one question pls!
My two pivot...Thanks for the tip.<br />one question pls!<br />My two pivots are not connected to each other. Meaning I want to put one pivot in filter and want to analyse data in 2nd pivot but it is not working. It might be because the two pivots are not linked<br />How can we solve this?<br />Thanks<br />AnkitAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-66175397879884744502022-03-16T14:59:10.655-04:002022-03-16T14:59:10.655-04:00See the "Single Table" section at the en...See the "Single Table" section at the end.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-21036613649346725552022-03-16T14:58:10.912-04:002022-03-16T14:58:10.912-04:00Yes, that's what this blog shows.Yes, that's what this blog shows.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-44690969276961045852022-03-16T04:37:41.584-04:002022-03-16T04:37:41.584-04:00Thank you Ken! But is it possible to do multiple p...Thank you Ken! But is it possible to do multiple pivots if we have only one table or only on excel in Tableau DesktopUMAPRIYADARSINI CHANDRASEKARANnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-77434755681536002022021-08-16T18:03:53.725-04:002021-08-16T18:03:53.725-04:00That is exactly correct. If Prep or Alteryx is ava...That is exactly correct. If Prep or Alteryx is available, I'd suggest using always using those. However, if you're in a bind or don't have those tools available, then this hack is available.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-69712887594289284652021-08-12T15:33:04.709-04:002021-08-12T15:33:04.709-04:00Thank you Ken! However the pivot is not available ...Thank you Ken! However the pivot is not available if our source is a query from a database such as AWS redshift, SQL server etc. Am I correct? In such case, we are better off using Prep/Alteryx or is there a way to tap into relationships?Kirannoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-36185546995502989172020-08-04T11:43:42.275-04:002020-08-04T11:43:42.275-04:00That's a nice trick!!That's a nice trick!!Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-79106563210833731382020-08-04T11:43:10.485-04:002020-08-04T11:43:10.485-04:00I agree that relationship calculations and inequal...I agree that relationship calculations and inequality will definitely help make it more viable.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-22929854824572180702020-08-04T11:01:10.709-04:002020-08-04T11:01:10.709-04:00Before 2020.2 and even before Prep, I would
(1) c...Before 2020.2 and even before Prep, I would <br />(1) concatenate the two fields Population and GDP Growth - <br /> ( change the datatype to string - concat with '|' inbetween the two fields) <br />(2) pivot (hiding the original two fields of course) and <br />(3) split and change the data type back to numeric.<br />Life is much easier now.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-28407278070087603582020-08-04T07:42:49.366-04:002020-08-04T07:42:49.366-04:00Very helpful tip, thanks for sharing. I think for ...Very helpful tip, thanks for sharing. I think for relationships really to take off, 2020.3 is needed. Without join calcs it is not so helpful. Matthiashttps://www.blogger.com/profile/13540159021520266760noreply@blogger.com