Tableau Questions

A couple of great questions came up in yesterday’s Tableau workshop.

The first question is how to display box & whisker confidence intervals?

This is not a feature I’ve worked with before as it is new to Tableau 8’s release in March 2013.   However after doing some digging around the Tableau’s website there’s a quick example provided at: http://www.tableausoftware.com/public/blog/2013/11/tableau-public-81-launches-2226.  If you’re looking for more detailed, longer example you can find one at http://www.tableausoftware.com/public/blog/2013/11/box-and-whisker-plots-2231.

The other question that came up was if you’ve gone to the trouble of creating several calculated fields but would like this to show up in your original data file, is there a way to do this?

As far as I know, the answer to this is usually.  The simplest way to do this is to right click on your data source (should be labelled data on the far left of the screen) and select “view data”.  This gives the data view.  From here you can select all the data and copy it to the clipboard (ctrl-a, ctrl-c) and then paste this in Excel.  One thing to be careful of is that Excel only holds 64,000 rows of data so if you try to copy/paste more you will find out that this will not work.  Tableau has instructions about this at http://onlinehelp.tableausoftware.com/v7.0/pro/online/en-us/save_export_data.html.

What if you don’t want your data in Excel?  Well, there is one alternative.  If you select Worksheet from the main menu (third option from the left) you’ll see you can select Export and then Data.  This will let you export a Microsoft Access Database.  Unfortunately if you want to export to anything else you are out of luck . . . but you should be able to find plenty of tools to convert from Excel/Access so you probably aren’t entirely out of luck.