Calculations in Tableau are Powerful! These posts either deal extensively with calculations or demonstrate techniques that use calculations.
Cross database joins have been available in Tableau for a while now – and I love the ability to join data at a row-level across various databases and files! And union functionality is available, but for now, only if you are dealing with tables in the same database (or files or Excel tabs). But what […]Continue Reading... No Comments.
Often, you’ll have data that looks something like this: Every day, there are new records for projects that give the latest status and count of hours used. Often a project spans multiple days and the status can change and count of hours might go up. But if I want to get the most recent […]Continue Reading... 2 Comments.
I used to think you couldn’t hot-swap geographic levels of detail in a Tableau visualization. And, before Tableau 10, you couldn’t. I mean, of course in Desktop or web authoring mode you can drag and drop fields, but for the end-user of a dashboard that wasn’t an option. You might have thought to use […]Continue Reading... No Comments.
I recently came across this post by Simona Loffredo in which she describes a certain type of data structure, why it wasn’t ideal for analysis, and how to reshape it using Alteryx. While I love Alteryx and really love how it can be used alongside Tableau, I get especially excited when I can do something without […]Continue Reading... 1 Comment.
Happy New Year! Even as 2016 was winding down, I found myself with a challenge dealing with time. And I thought I’d share some of my thoughts about a possible approach. Here’s the challenge: You have a database with transactional data, that is data where the rows are inserted, updated and deleted based on events. […]Continue Reading... No Comments.
I really love the Tableau Community Forums. If you haven’t ever experienced the forums, you really should! It’s a vibrant community all centered around helping people learn Tableau and solve real world problems! You can participate as a helper and provide answers to individuals who are asking Tableau questions or ask for help if you have a […]Continue Reading... 5 Comments.
As I’ve been beta testing Tableau 10.0 and working on a new edition of Learning Tableau, I’ve been making all kinds of little discoveries. Big new Tableau 10.0 features like clustering, cross database joins, cross data source filters, union updates, Google Sheets are exciting! But little tweaks, cool UI additions, and little new features the Tableau […]Continue Reading... No Comments.
Ever design a table in Tableau and wish you could insert a gap between columns or rows? Maybe you want to show several values, but set one apart from the others. Something like this: Or maybe you want to create some space between categories, like this: Whatever the reason, in some cases, it’s actually quite […]Continue Reading... 4 Comments.
In a previous post I shared how even a small tweak to a dataviz can change the perspective of the data story. The example I gave demonstrated how a view that used absolute time (with date defining the axis) presents a different story and highlights different insights versus a similar view that used relative time […]Continue Reading... 2 Comments.
The Problem of Partial Periods So you built out that incredible Tableau* time series viz showing sales per week or number of widgets produced per month. Everything looked great as you wrapped this up right before Christmas break. Profits were up, sales were great, trends were positive. You come into the office excited to start […]Continue Reading... 6 Comments.