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.
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?
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…
Most programs like Excel, Tableau, Microsoft SQL Server and Alteryx have a built in Date Difference (DATEDIFF) function. This function is great at letting you set a unit of measurement (i.e. year, month, day) and calculate the difference between a start and an end point.
I was working with a client recently and needed to do find and replace in a Tableau calculation. While Tableau does have a native FIND() function, it just finds if a character string exists and tells you what position that string starts at. Not particularly helpful when it comes to replacing.
A client recently challenged me with the question, “How could I show a bar chart in Tableau that shows values for the top 10 displayed as 10 individual bars but group all the rest of the values into a single bar called “other”…
If you're familiar with Level of Detail expressions in Tableau, you probably know that the FIXED function gets all the love. However, there are some great reasons to consider using the other two as well. Check out the above video to learn when to use the EXCLUDE function.
Imagine you have a busy worksheet in Tableau that looks like this:
Each line represents a single facility and displays that facility’s overtime hours. Imagine you want to filter to only keep the trends for the 3 facilities with the highest overtime hours from the most recent date BUT you also want that filter to be dynamic so when you update the data there might be a new top 3.
If you have a data set that updates irregularly, figuring out how to filter to show only the latest data is difficult. Relative Date Filters are great but only work well if you have a set time you are filtering to like “today” or “yesterday”. If your latest data could be today, yesterday, or two days ago depending on the refresh schedule, things get trickier.
Let’s say you want to compare a value from today to the same day last year to evaluate performance…