From the course: Tableau 10: Mastering Calculations

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Identify the percentile of a given value

Identify the percentile of a given value - Tableau Tutorial

From the course: Tableau 10: Mastering Calculations

Start my 1-month free trial Buy for my team

Identify the percentile of a given value

“

- [Instructor] One way to analyze data is to determine the relative rank of each value within a data set. A percentile rank, which indicates the percentile values of the range that are above and below the value you're examining provides useful insights into specific values and the range as a whole. In this movie, I will show you how to calculate the value that is the cutoff for a given percentile. My sample file is the percentile workbook, and you can find it in the Chapter02 folder of your exercise files collection. This workbook contains a straight forward visualization, and it shows the average total cost of orders for five product categories. I'd like to calculate the cutoff value for percentiles. For example, if I wanted to find the value for furnishings orders at which 70% of the orders would be below the value, and 30% above, then I could calculate the 70th percentile value. The percentile value serves as a cutoff.…

Contents