

So, who can tell me the most popular first name in Superstore Sales? Answers in the comments section below please, or you can tweet me.ĥ. Tableau will automatically try to figure out the delimiter and split the data accordingly, but you can also choose Custom Split and specify the delimiter yourself if you like. Just right-click on the dimension you want to split, navigate to the new ‘Transform’ menu and click Split. What typically used to be a job for Excel, SQL, or a calculated field of LEFTs and RIGHTs has now been made a one-click operation in Tableau. If there are any Tableau devs listening, maybe you could reintroduce that before the release? One thing I would say is missed in this new version is the hyperlink out from that calculation window to the formulas help page on the Tableau site. While we’re on the subject, don’t forget to check out some of the new calculations introduced in v9, like the RANDOM(), HEXBIN, and REGEXP functions. It’s a nice way to keep the interface clean while still giving you the option to search the formula list. But wait, what’s that little arrow off to the right of the window? Click it, and voila, you get your formula drop-down, complete with explanations and a usage example. I mean, where did all our drop-down menus go allowing us to choose what function to use? Well, now that the new calculation window auto-completes your typing with suggested dimensions, measures and formulas, you could argue that these aren’t really necessary any longer. We were a little worried at first at the minimalism of the new calculation window. The little arrow to the right of the new calculation window The new and improved colour palette dialogue box now allows you to specify and see hex values for all the colours you’re using – very handy for putting together those custom colour palettes, and what’s more you can now also pick a colour from anywhere on your desktop and drop it into the palette.

Updated colour window with hex values and colour picker rda – the file formats employed by the R statistical analysis packageĢ. sav – the binary file format used by SPSS

Got stats files that need visualising in Tableau? This new connector brings native support for a number of statistical package files including: Direct connector for stats package files – SAS, SPSS, R Here at The Information Lab HQ we’ve been testing (and playing) with the beta versions of Tableau Desktop v9 for a few weeks now, and I’ve put together a list of 10 little-known improvements in v9 Desktop that we think are pretty cool, and will almost certainly bring joy to the Tableau enthusiast and save them lots of time and effort. With Tableau version 9 now in beta and due for release in the not-too-distant future, there’s a lot of buzz in the Tableau community about all the new headline feature enhancements, and there are quite a few to shout about! New features like parallel processing are set to deliver massive performance improvements, while the new level of detail calculations will make once complicated table calculations child’s play.īut there are also dozens of little enhancements that haven’t necessarily made the headlines, and that’s what I want to talk about in this post. | Jonathan MacDonald 10 new features in Tableau v9 you may not know about
