I have a column called line_char, which displays the category according to a parameter that was created.
I have this field in the columns and a date in the lines that is displayed every Sunday of the month. I use it as the exact date.
I created the rank_unique based on the number of HCs. I used it with fixed, with exclude and without, but it always displays the same ranking value for the same category. When I remove the date, it works as it should. How do I make the column respect the rank value according to the value and ignore the date? Can anyone help me?
Your table calculation can calculate the rank of each category within the month, each month within the category, or the rank of each data point across both category and date. If you only want the top N lines to be shown, i.e. the highest total category within the time period, then you should use a Top N filter, and add your date filter to the Context. Top N filters are calculated before Dimension filters, so you either filter for the Top N including all the data, or you add filter(s) to the Context to move the filtering earlier in the order of operations:
Tableau's Order of Operations - Tableau
I aggregated your dates to the month, because not all categories have orders on every date, and the missing values can be confusing, though the output will still be correct. If you actually want to plot the highest N categories in each month, then you will get more than N categories, and the lines will be broken.
