Have you ever spent waaaaay too long trying to format a number in Tableau? Did you ever change a number format but see no change in your worksheet? These little things can be maddening!
Measure Names and Measure Values - they seem to be everywhere! In your data pane, appearing magically when building certain graphs and views… But what exactly are they for?
Measure Names and Measure Values are Tableau generated fields that allow us to reference all the measures in our worksheet.
Tableau is a fantastic data visualization tool, but memorizing some of the initial data visualization rules is hard. It might only take a few clicks to create a scatter plot or a highlight table, but you need to know exactly *which* clicks to make in order to create those charts.
Tableau Sets are custom fields which allow you to define subsets of data. They can be used in a variety of ways to make charts more intuitive, interactive, and functional!
One of my favorite, underutilized charts is a dot plot! A dot plot is like a 2-D Scatter Plot and it's great for visualizing ranges of data. Often, I'll pop an average line on the chart for reference so the user can compare across categories as well. I hope this chart type serves you well!
“How do you display counts in Tableau?"
I accidentally stumbled upon this popular Google search question and it looks like a lot of people are inputting this query!
It turns out, there are multiple ways to display counts in Tableau. Which method is right for you all depends on what you're trying to display the count of.
Tableau Prep is a powerful tool for cleaning and shaping data. One of its weaknesses is that it can be slow on a desktop computer. There are a number of reasons for that (computer memory limitations, size of data source, complexity of steps, etc.). One of the ways that Tableau Prep conducts these performance issues is to sample your data automatically.
Have you ever tried to add a label to the end of a stacked bar chart in Tableau? I'm guessing it didn't work the way you wanted!
When you add a measure to the Label section of the Marks card, it adds a label to each section of stacked bar chart rather than an overall label for the entire bar.
Sometimes, users need to see the same data multiple ways to develop thorough insights. Providing your user the ability to switch worksheet types (e.g. swap a map for a bar chart) is a great way to provide them with flexibility in analysis!
One of my favorite tricks in Tableau dashboarding is to allow users to swap worksheets! You can hook a parameter up to a calculation which filters/swaps between multiple sheets in a Tableau dashboard.
There are three certainties in life; death, taxes and running out of space on your dashboard.
We've all been there, right? Our business users want to squeeze "just one more sheet" onto an already crowded view. If that sheet is a bar chart, I've got a space saving tip for you. Could you overlay the dimensional labels at the beginning of the bars to save some space?
How do you join two tables together in Tableau when they don’t share the same common field? Or what if that common field is slightly different in both tables? A Join Calculation can help solve a lot of those problems! In this video, we take a look at how to use a join calculation to join tables with mismatched fields.
Users love text tables. No matter how much we steer them toward data visualizations that do a better job of exposing patterns, outliers and areas of interest, many users are still most comfortable viewing data in a table.
…
One of my favorite solutions is to have the text table expand / appear when users make a selection and collapse / disappear when they deselect a value.
So you are making the jump from Excel to Tableau? Great!
You've probably noticed some of the functions you love so much in Excel don't exist in exactly the same format in Tableau. Take SUMIF and COUNTIF as an example. Tableau has an IF function, a SUM function and a COUNT function, but not SUMIF or COUNTIF.
So you want to concatenate multiple text values in Tableau, huh? Great!
In some ways, this process is easier in Tableau than Excel or other data-related tools. Whether you are concatenating string fields, static text, or even text-based parameters, all you need to do is add a plus sign between your values!
Does your dashboard feel cluttered because you're trying to communicate too much supporting information to your user? Making sure you cover everything your user needs to know can leave your output feeling more like an essay than a data-driven dashboard.
Info buttons are a staple of Tableau dashboards. They allow you to pack so much additional information to a dashboard without cluttering the view for users.
Do you know the difference between measures and dimensions in Tableau? How about discrete and continuous fields? These are common points of confusion for Tableau Desktop users. Knowing the difference allows you greater control and customization as you leverage fields for visualization in Tableau. In this video, we review what you need to know to use discrete and continuous fields to build the visuals you want to see!