Hi, its because your rank function only gives a rank where there is data. So the fourth model starts at a later date, so it doesn't have a rank until a later date. The brown line in this workbook is your rank function, hopefully that illustrates why filtering based on that gets weird.
An easy way to get a top N, is to create a set. See the filter "Set 1" on the second sheet of the attached. Also, see here... Create Sets for Top N and Others | Tableau Software
Sample workbook.twbx 531.1 KB
Chris. do find that the use of set as you mentioned is workable solution. Thanks!
Regarding the part you mentioned about rank function only gives a rank where is data...So you mean that models 3017c and 3308i is not ranked? But if so, why does it show up in the chart?
Further, is there any way we can edit it such that the "Rank" can be used as a filter directly?
1 of 1 people found this helpful
There will only be a rank for the the months that there is data.
So for example, 3017c doesnt have a data until august so 3308i actually gets ranked 4th until august. In the picture below the brown is the rank. See how it goes up slightly from 4 to 5 once the data exists for the 3017i?
I'm not sure about how to work around this using the table calcs. Theres probably a way but it could be a little complicated.