This content has been marked as final.
Show 3 replies
-
1. Re: Filtering aggregated data
Jonathan DrummeyMay 26, 2012 4:03 AM (in response to Hari Venkat)
Hello,Attached is one solution. I used a calculated field called Count Car Field:IF COUNT([Car #]) = WINDOW_MAX(COUNT([Car #])) THEN 1 ELSE 0 ENDDrag that field onto the Filter Shelf, and set the filtered value to 1.By default, the Compute Using for this field in the view is set to Table (Down), so it will compute only one maximum for the whole table. To get it to partition on Year, set the Compute Using to to Car, so the calculation will be computed for each car and restart for every Year.Cheers,Jonathan-
filtering for top count.twbx.zip 38.0 KB
-
-
2. Re: Filtering aggregated data
Hari Venkat May 26, 2012 8:12 AM (in response to Jonathan Drummey)1 of 1 people found this helpfulThanks for the assist!
I figured out a similar way this morning, but your method should be useful for other similar situations.
Basically, I used a table calculation on CNT(Cars) and chose the Pane (down) option. I used a custom formula for the table calculation (which is pretty much the same as the one you wrote up) setting all non-max values to null, then filtered out the nulls.
-
3. Re: Filtering aggregated data
Jonathan DrummeyMay 28, 2012 7:43 AM (in response to Hari Venkat)
Hi Hari,
Like many situations in Tableau, there are multiple ways to reach your goal.