Ah, the month-on-month comparison. I’m not going to bore you with a sermon on the ins and outs of monthly comparisons, but I do want to explain what this particular variation accomplishes. In my previous post on comparing an incomplete week to the same days of...
The latest question from Tableau Training comes from Andy, who was in a DII: Intermediate course in Toronto, Ontario. “I need to match the colors on my charts to my company’s style guide. Is there a way specific colors can be chosen rather than the default...
For the past few months, I’ve been working with a client for whom tracking performance is a matter of life and death. Okay, maybe it’s not that dramatic … but they care a lot about player engagement and revenue streams for the video games they...
Time for another question from Tableau Training, this time a question asked by Daniel from a DII: Intermediate course in Kuala Lumpur, Malaysia: "I want to show my actual sales on a line graph, but I also want to combine that to show budgeted sales after...
In our final article in the Deep Dive on Dates, we’ll explore how to take a start date for different products and normalize it to a wee- by-week comparison from week one forward. This article was inspired by one of my Desktop I: Fundamentals students from...
For this article in our Deep Dive on Dates, we’re going to build a filter in the form of a calendar. Our user can select an entire month or a series of days to create a subset of data on the dashboard. Here’s a preview...
Above: The InterWorks Europe crew onstage. Thrilled does not cover it! With over 300 Tableau partners attending this year's EMEA Tableau Partner Summit, InterWorks were delighted to be awarded Services and Training Partner of the Year for the second year in a row. So, what does that...
Let’s continue our exploration of dates in our Deep Dive. In Part 6, we’re going to focus on how we can create rolling dates. A rolling date is taking a specific date, such as order date, and then adding a certain amount of days, months or...
Let’s continue on with our Deep Dive into Dates. This article, we’ll explore custom dates. The name admittedly is a bit of a misnomer and only really make sense if you understand date parts and date values. Make sure to catch up on this series...
We’re continuing our Deep Dive into Dates with an examination of the Exact Date value. Remember to catch up on the previous three articles where I introduced dates (discrete vs. continuous) and some key date functions. Let’s get started! Exactly What is Exact Date? In our first...
We’re continuing our Deep Dive into Dates with further exploration into date specific functions. In this article, we’ll cover DATEADD, DATEDIFF and DATETRUNC. My goal is not only to show you how to use them but to give you some real world examples of when they’d be...
In the first article on the Deep Dive on Dates, I introduced some of the basic concepts of dates. Specifically, we covered discrete vs. continuous dates, dart parts vs. date values and some basic date functions (DATEPART, YEAR, MONTH and DAY). In this article, we’ll...
Dates are one of the most confusing topics that come out of Tableau training. What is the difference between a continuous date and a discrete date? What is the difference between those and normal continuous and discrete fields? Why isn’t my date field showing up...
Here’s a question I got from a student named Summer in a DII: Intermediate course in Hong Kong: "I want to show all of the cities in the United Kingdom for a particular measure but only show city name labels for the top five." Awesome question! Let’s...
In last article in our Deep Dive on Sets, we will explore how we can use sets inside of a hierarchy. It adds dynamism to your hierarchies, particularly if you nest multiple computed sets into a single hierarchy. Let’s learn how to do it! Hierarchy Overview A...
The last two articles of this Deep Dive are going to focus on some advanced uses of sets. We’ll start by looking at how we can use sets in calculated fields. It doesn’t matter if the set was created manually or if the set is...
We’ve created manual sets, and we’ve created computed sets. Now we are going to extend the functionality of our sets once again by using two sets to create a combined set. This allows us to create additional analysis to compare, contrast or even combine the...
In all of our previous examples of this Deep Dive, we’ve been adding our new sets to the Filters card. That’s filtering our view (as well as limiting the membership available in our filter control as we did in part two). What happens if we...
Computed sets use logic to dynamically update the membership of the set. This is the key distinction between constant sets and computed ones. Changes to the data will change the set itself as it re-computes what gets classified as IN the set and what gets...
Constant sets are sets that once created do not change. If the underlying data changes, the membership of the constant set does not change to reflect these differences. These are also known as manually created sets. In this part of our Deep Dive on sets,...
Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson
Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301
Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072