Imagine you are working in Tableau and want to create a worksheet that compares performance this quarter to date to performance last quarter to date. Depending on the visuals you’d like to create, you’ll likely need to create a calculated field for this to work properly.
We all have to make decisions in life. Some of those decisions are small and have minimal impact (e.g. What should I wear to work?), but some of those decisions have significant, long-term impact.
Have you gotten the error “All fields must be aggregate or constant when using table calculation functions or fields from multiple data sources” in Tableau?
Data scaffolding allows you to generate missing data for visualization purposes.
I’ve seen several examples of people turning their resumes into Tableau dashboards recently and I wanted to try my hand at it and write a blog post about the process.
Imagine you are working with a data set in Tableau that displays minutes and seconds in decimals. For instance, 1.5 would be reflective of 1 minute and 30 seconds…
Imagine you work for a company that sells products but not in every market. Because you don’t sell certain products in given markets, you have null values in your data.
In June, 2018 I wrote a blog post about three things Tableau Prep couldn’t do. One of those was the ability to transpose (unpivot) data. That is no longer the case. Tableau Prep Builder now gives you the capability to transpose rows of data into columns. Let’s look at an example.
In June, 2018 I wrote a blog post about three things Tableau Prep couldn’t do. One of those was the ability to transpose (unpivot) data. That is no longer the case.
Working with data that isn’t clean can be a pain. One of the most frequent data issues I come across is dealing with duplicated rows of data.
Imagine you have a dashboard that looks almost exactly the way you want. The data looks great, the visuals are just right, but the colors are a little off…
Imagine you’ve run into a scenario where you want to be able to show a little more information on your dashboard but it makes it feel too cluttered. However, it’s not nearly enough extra information that it warrants creating an entirely separate dashboard. This is a great opportunity to use a little known feature in Tableau that allows you to expand and contract worksheets in a dashboard.
Have you ever had an experience in Tableau where you set a filter but don’t get the results you expected? There are multiple reasons that can happen. One of them is that you can set multiple filter criteria in a single pill on the Filters Card.
URL actions open up a new world of possibilities in Tableau dashboards. You can link to a URL field, look up a data point of interest, or even create an action that creates an email form. URL actions have been used to successfully linked sales opportunities to Salesforce, link furniture companies to their products on the web and generate emails to further discussion about data points of interest.
I recently finished a book called, Astroball written by Ben Reiter. It tells the unlikely story of how the Astros went from the worst team in baseball to winning a World Series a few seasons later. As much as I wish I could say I didn’t like the book (I’m a Mariners fan after all) it was a compelling read and gave me great insight into their organization and methodology.
Creating a calendar visual in Tableau can be an effective way of communicating data-based information to your end user. For example, using a calendar in an effective way of seeing that sales are highest on Saturdays for this restaurant.