Rank & Filter the Top 5 in Tableau in Under 60 Seconds!

preview_player
Показать описание
In this tip, you will learn how to show the rank of each team in MLB by homeruns for 24 seasons.

We'll start by computing the RANK table calculation for each Season before filtering to only the top 5 Teams in each Season.

The data is embedded in the workbook.

  1. Andy Kriebel
  2. tableau
  3. tutorial
Рекомендации по теме
Rank & Filter 0:01:07

Rank & Filter the Top 5 in Tableau in Under 60 Seconds!

Find Top Employee 0:13:40

Find Top Employee with FILTER, SORT and RANK Function in Excel

Power BI DAX: 0:06:01

Power BI DAX: Rank Top N Accounts with calculated measure for visual filter based on user selections

Excel Rank Top 0:12:19

Excel Rank Top N Values Inc Tied Values with Dynamic Array Formulas

How to Filter 0:03:57

How to Filter by Rank Across Multiple Worksheets

Power BI Rank 0:05:49

Power BI Rank Within a Group Using the RANKX Function #Q&A

Excel Pro Trick: 0:02:30

Excel Pro Trick: Make Top 5 Ranking Chart in Excel Show Top N values with position number in Excel

Tableau - Top 0:05:50

Tableau - Top and Bottom N using Rank function

Rank your values 0:12:55

Rank your values using RANKX DAX Function in Power BI // Beginners Guide to Power BI in 2021

How to Show 0:10:35

How to Show Top N within each category using Rank in Tableau

DAX Fridays! #10: 0:11:26

DAX Fridays! #10: RANK/ TOPN with slicer

DYNAMIC TOPN Ranking 0:15:26

DYNAMIC TOPN Ranking using PARAMETERS / Let Users Control Top Values / Beginners Guide to Power BI

RANK function in 0:05:40

RANK function in Excel and Rank by groups by Chris Menard

TOP AND BOTTOM 0:09:14

TOP AND BOTTOM 10 CUSTOMER IN POWER BI | RANK FUNCTION IN DAX

Ranking Filter Template 0:06:05

Ranking Filter Template + Tutorial für Effect House ( TIKTOK )

Excel Rank Function 0:05:14

Excel Rank Function with different ranks for same values

Dynamic Rank range 0:04:09

Dynamic Rank range Slicer in Power BI| Select Dynamic Ranks from Slicer

DYNAMIC TOP/BOTTOM RANKING 0:15:38

DYNAMIC TOP/BOTTOM RANKING using PARAMETERS // Beginners Guide to Power BI in 2023

Rank by multiple 0:05:04

Rank by multiple criteria in Excel

Top N within 0:07:12

Top N within Partitions/Groups/Category - Tableau Rank Function

Tableau Tutorial 122 0:04:09

Tableau Tutorial 122 - How to use Index function for ranking data

Power BI: Dynamically 0:06:45

Power BI: Dynamically top N rank for multiple columns in the matrix using RANKX, SWITCH & ISINSC...

How to Rank 0:13:18

How to Rank Duplicate Values in Excel without Skipping Numbers (Top 3 Report with Duplicates)

rank these 6 0:01:01

rank these 6 foods

Комментарии
Автор

Hi!
Could you please help understand how to get correct column totals here?
If you add column grand total or subtotals - you'll get values for full data, not the one you filtered out.
It doesn't depend on if I apply 'apply to totals' feature or no to the filter. Just check by yourself.
Greatly appreciate any help.

vspjnml
Автор

yes, the point was to show how to rank the top 5, but the Astros only hit about 250 home runs in 2000, not 13, 695 as the data is showing. The season is 162 games long and if they hit 13, 695 home runs, they were sending, on average, 84 balls a game out of the park. Yes, 2000 is in the steroid era, but 84 dingers a game? :)

zimmejoc