Forum Discussion
Helper ISorting a Date Table with Broadcast Dates
Super UserHi hoyt22, I'm afraid it's impossible to achieve the desired result in the way you formulated the task. You're on a right track when thinking of using "sort by another column feature". This is indeed the preffered way to resolve similar cases, however in your case the same value might have more than 1 value, which is not allowed.
Let's take 29th as an example: depending on year-month, it might be within a week that is within the same month or different. Therefore, the same value of "Broadcast Day" might have 2 different values for any type of "sorting by" column.
To obtain the desired result, you might consider using other columns:
- date - this is unique and you have the order, therefore it will be sorted correctly
- day of week - also day of week will work as its values from 1 to 7 (or 0 to 6 depending on your time zone) will always respect the rule of 1 sorting value per 1 column value.
I hope it will help you! Good luck with your project 🙂
hoyt22Sergii24 Thank you for your assistance! I'd love to pick your brain further if you can help.
By Date:
I do see that using Date will work, but the date is just too long to make the chart look nice. Is there a way to create a column with a shortened version of the date that won't cause the same problem with sorting? I know I can change the format in the Column Tools menu, but there's no option to just show the day. Even showing "mmmm d" looks a bit long, though it's doable if it's the only option.
Day of Week:
I tried creating a Day of Week column, and when I tried to sort Broadcast Day by Day of Week (1-7), I ran into the same "more than one value" error. I may have misunderstood your comment. Were you using Day of Week to sort or just use in the chart?
I appreciate your help!