If's, And's, Cases and In's Logical Operator's – How to's

Logical functions like If/Then , Cases, And/Or or In statements are a fundamental part of creating customer vizzes – and they are not that hard to understand and use.  Here we will look at what each statement does, its syntax, and some use-case examples  1 If/Then statements Conditional statements all work in pretty much the […]

Fiscal Calendar YTD and PoP

The most frequently searched post on my blog is on how to do YoY and YTD calculations. But it only works with actual calendar dates. Those of you who have to use a fiscal calendar face an added problem – Tableau date functions only work with actual calendar dates.  Here we will look at how […]

Calculating Averages or Rates – How To

We see and use averages every day –  Average rainfall, MPG, or sales per day for example –  You learned how to calculate them in grade school but what makes Tableau different?  The average is simply equal to:   That's easy to understand and yet counting values in Tableau can create problems –  Example 1 […]

Filtering Fixed LODs

Using filters with Fixed LODs causes problems for many users.  Here we will see "How-to" write a LOD When and how to apply Context or Dimension filters Effect filters have in 2 common use cases Probably the best place to start is with an understanding of what Fixed does and then move on to how […]

Parameters – How-to and Use Cases

For new and more advanced users, alike Parameters are misunderstood and misapplied!   Parameters are a function that allows the user to manually input a single value into a Tableau workbook.  Not that difficult –   Manual input – not based on a calculation or another field – the value can be any data type […]

Just what does Include or Exclude Do

Include and Exclude – the other 2 LODs – How often do you use them? If you are like most, less than 20% of the time. So what do they do and when do you use them?  – confused?   me too! Here we will focus on how to use the Include and Exclude forms of […]

Viz-In-Tooltip

Viz-In-Tooltip adds versatility and makes it easy for your user to get to the story hidden in your data.  They are not difficult to use and let users see the detail without leaving the face of your worksheet – OK I'm sold – but what are they?  Hovering over any mark on the worksheet opens […]

Table Calculations – When, Where and How

Want to total across the row or column, rank a dimension, or pick out a single value? Then you need a Table Calculation!  But how?       Table Calculation Basics Table calculations should feel familiar.  They operate on the table you see in the view much like those from spreadsheet calculators.  The actual "data […]

Drilling down in Top N and Other

A frequent user question is how to find the Top N and then group and total all the remaining items into a single category "Other"     A common problem with many business applications – determining the Top N can be easily done in several ways.  (Presented on VizConnect – see the recording at Link […]

Sets and Filters the Condition and Top N Tabs – What do they do?

How often do you use the "Condition" or "Top N" tabs – and have you ever used them together? See how…   Here we are going to look at how to use Conditions and Top N in combination with Sets and Filters –      The Condition and the Top N tabs are on the […]

When and How to Scaffold Data

When and How To Use Scaffolds    The data structure has a huge effect on the results you get from your analysis. Like most of you, I trained using well structured and full data sets – where there was a value in every record (cell) – like a tightly fit puzzle  (Note – Presented that the […]

Net Promoter Score

Recently I had someone ask about calculating the Net Promoter Score in Tableau. It's not difficult but first a word on what the NPS is and who uses it –   The Net Promoter Score is often used by consumer products companies to measure customer loyalty. It is easy to administer – just collect consumer […]

Duration and Time – Not the same thing

 Time and duration are not the same – Time can be read from a clock – duration is the accumulation on intervals – and although we use a common terminology  – hours – minutes and seconds they are different    This example uses a simple data set consisting of project start and end times by employee   Date Functions […]

Creating Groups

Groups are a way to collect like items without creating an aggregate  – They can be static or dynamic, created manually, through a join or as the result of a calculation and spreadsheet users will find them as a useful replacement for a VLOOKUP – Manual Grouping Static groups can easily be created using the […]

Parameters and Parameter Actions

Do you use parameters – I love them and use them a lot – Let's look at them in more detail   Parameters are one-way users can directly input a value into Tableau.   They are: Single valued –  have one value at a time  Static the value is constant until manually changed by the user  […]

Show – Hide Filters

Show – Hide Filters   Often we will see a Forum question on how to "Filter the view without filtering the underlying data?"  Really?      What's going on?    Load a data set into Tableau, open the Data Source tab, and look at the data – It is the complete data set      […]

Cannot Mix Aggregate and Non-aggregate

Cannot Mix Aggregate and Non-aggregate  One of the most frequent questions we see on the Forum results from trying mixing aggregate and non-aggregates in the same calculation – But why is that a problem and how do you resolve it –  Next time you load a data file into Tableau, open the data source tab and […]

Put life in your Viz with Set and Parameter actions and Viz in Tooltip

Set and Parameter Actions and Viz In Tooltip  Add life to your vizzes and make it easier on the user by using set and parameter actions and "viz in tooltip"   Set Actions Set actions added to the dashboard are an easy-to-use alternative to the drop-down filter. In the dashboard below – the map provides a visual way […]

Dynamically sort Top N in a Drill Down Hierarchy

Dynamically sort Top N in a Drill Down Hierarchy Lately, the Forum has been peppered with questions about sorting, ranking, application of filters, and how to make the sort “Dynamic”.  So I thought I would take some time to go through a few examples on how to sort in most situations   Let’s start at the beginning with examples […]

"How to" Create a Normal Distribution Curve

 How to Create a Normal Distribution Chart  Occasionally there are Forum questions on creating normal distribution curves.        The approach here relies heavily on the concept of data densification develop and refined by Bora Beran, Joe Mako, Jonathan Drummey, Ken Flerlage, and others – Readers are encouraged to review their works on creating shapes and […]