I'm so glad I came across this post when trying to wrap my head around the functioning of the Sankey diagram at work. It can be a bit of a painful process, but it works. You then have to go back and edit the table calculation, setting all the nested calcs to compute as desired. The only way I've found to deal with this is to right-click on the red pill then set it to compute using some field (any field will do). My best guess is that there is some missing pointer somewhere that causes it to get confused. I've found that advanced table calculations, especially those with lots of nested calcs, sometimes get errors like this even though everything looks good under the covers. Despite all your efforts, you won't find a way to fix it. If you hover over the calc, it will say that a field is missing. If you need to do this and get stuck, please feel free to contact me and I’d be happy to help you out.įor a more detailed explanation of how to add additional curves, see the following post on the Tableau Community Forums: Adding Steps to a SankeyĪ note of warning: Often, when you copy the sheets then switch the calcs to use the new ones you've created, you may find that one of the table calcs turns red, indicating an error. The process was quite simple and it only took about 20 minutes from start to finish. From there, all I had to do was to replace references of his column names to my column names. I brought that into the Tableau workbook template as Custom SQL, replaced the “Data” sheet, and created a join calculation of 1 = 1. I simply structured my data using SQL to include the data points shown in his Excel template. I recently utilized one of Ken’s Sankey templates at work, specifically the multi-level Sankey template. Not convinced? Here's a quick testimonial from my brother, Kevin Flerlage: If you can get your data into the basic structure of the template, either through use of data prep tools, such as Tableau Prep, or custom SQL, then you can easily replace the data with your own. Finally, before closing this out, I wanted to note that I often have people tell me they can’t use these templates because they can’t put their data in Excel.
1 Comment
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |