Forum Discussion
Sort table by date
So to help people who got the same problem, the best way to resolve it at the moment is to place the column on the right of the board, go to the focus mode and hide it on the left
On this way my table's tab looks like that :
So Date is hiden, (you just see a small part of the tab)
It's not perfect, but I don't have any idea to do better...
As you have shown in the screenshot, you can not sort this table by dates without adding the date column in your table or in other words, you have to have a date column in your table to sort your data by dates.
Hope this has clarified your understanding.
You might be able to go into your data model and choose the Modeling tab and then set the "Sort By Column" for one of your other columns to be the Date column.
Thanks for your help, but I am not able to do this, like you can see on the following screenshot
You need to go into your data model (middle icon on left) and then select your table and then select your column and then Sort By Column should activate.
Yes, I also did this, but even like that when I delete the column "date" , the table is shorting by the "cost"
Still not work...
Apparently, the reason is that I have several same value on my colomn "cost"Oh yeah, nevermind, duh. The issue is that it wants a 1:1 relationship between the two columns. So, yeah, that was a dumb suggestion on my part. Hmm. Thinking...
Thanks to try ;)
In the worst case, if it's not possible to sort my table by date without deleting my column date.
Do you think that it would be possible to just hide this column (like on excel) in my table vizualisation ?