Forum Discussion

Helper III

1 year ago

Solved

Sort by most recent events first?

Is it possible to sort by the most rcent data input? If so, how would this be done?

Uzi2019
1 year ago
hi Sonyat810

as you can see just simply apply your sorting on year + day

like below or sort the table using 3 dots.

I hope I answered your question!

11 Replies

mh2587
Super User
1 year ago
If its numerical column then yes, If not change the data type
- Sonyat810
  Helper III
  1 year ago
  How can I do this?
  - mh2587
    Super User
    1 year ago
    If a text column you need to find the unique numerical column for that and you can use sort by column option.
Uzi2019
Community Champion
1 year ago
Hi Sonyat810

You can simply use shift + select column name for multiple level of sorting in table visual not in Matrix viusal.
- Uzi2019
  Community Champion
  1 year ago
  hi Sonyat810
  
  as you can see just simply apply your sorting on year + day
  
  like below or sort the table using 3 dots.
  
  I hope I answered your question!
  - Sonyat810
    Helper III
    1 year ago
    I figured it out . Thanks
- Sonyat810
  Helper III
  1 year ago
  I get this error.
  I’m interested in being able to see what happened in the last x days.
  - Uzi2019
    Community Champion
    1 year ago
    Hi Sonyat810
    
    why are you sorting by other column??
    
    use visual setting 3 dots > then sort > Asc/Desc
    
    I hope this might help...
Bibiano_Geraldo
Super User
1 year ago
hI Sonyat810 ,

For scenarios like this, i recomend you to use the date instead of date hierarchy, in this way, you will sort the column with just a click:

If you're using date from the calendar table, just make the calendar table as date table: