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.