use Rank_Unique as First Pill for this
1 of 1 people found this helpful
HI Suzanne, do you only need to sort by Date, or do you need to also be able to sort by the other fields? Also, could you share a screenshot of the entire sheet so we can see how you have the fields/colors set up?
Can you just create a calculated field called "Milestone date for sorting" and make it equal to the Milestone Date. Then place that new calculated field as the first pill on the Rows shelf, and un-check the "Show header" item for that pill, so the column is hidden. The line items on that worksheet will now be sorted by that field first, before any other sorts take effect.
Hope that helps.
Creating a date for sorting works if the date field is discrete. I need continuous because I need the exact date. When I pick exact date, it pushes the pill to the right and treats it like I am putting in an axis.
I’ve attached a new file, with the same issue, just not sensitive information.
After clicking on exact date it changes to continuous then again you can click on discrete which will give you the exact date in discrete format and you can use it for sorting
After it moves the pill to the end of the row shelf, right click it again, and select Discrete. It will turn it back into a blue pill, and then you can drag it back to the beginning of the Rows shelf.
This is really close but I end up with two problems. The sort gets messed up because I have some dates where I have two records so it isn’t sorting correctly.
Also, I lose my ability to color code my record.
I’ve attached my sample workbook.
Sort Data.twb 85.9 KB