From the course: Tableau 10 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Calculating averages, medians, minimums, and maximums

Calculating averages, medians, minimums, and maximums - Tableau Tutorial

From the course: Tableau 10 Essential Training

Start my 1-month free trial

Calculating averages, medians, minimums, and maximums

- [Instructor] When you analyze business data, you will often want to discover what represents a typical value and what represents the maximum and minimum of the value range. There are a number of ways to calculate what are referred to as measures of central tendency, but I'll focus on the average and the median. I will also show you how to find the maximum and minimum values in a data set. As my sample file, I will use the average workbook, and you can find that in the Chapter Five folder of your exercise files collection. I have a data list here. It is a text table, and it shows the number of guests on a given day for the 20 properties where my company has a hotel. At the bottom, you can see that I have added a calculation that shows the grand total. And if I go over to the marks card, I see that I have the sum operation in place. And that is why we see the grand total at the bottom, which is the sum of all of the prior values. If I want to change the summary operation, then I can…

Contents