Ability to Sort by Date in RTables, such as Table > Raw Data > Variables
backlog
J
Jade Goose
Take Cola Tracking data, for example.
Step 1: Table > Raw Data > Variables
Step 2: Select Unique Identifier, Interview Date, Age (doesn’t really matter, the important variable is Interview Date).
Step 3: Sort on Interview Date (either ascending or descending) and note that the values are sorted alphabetically.
This is unlikely to be the intent of the user when sorted.
Feature request is to allow the user to change the variable type to be Date and sort it sensibly.
J
Jamie Morris
Merged in a post:
Force Date/Time variables to be treated as numeric when sorting
T
Turquoise Swan
In this case, a user-created a table using variables. When they sorted on the date/time column, not all dates were showing in chronological order. This was because there were 0s missing from some of the DD and MM values. We had to advise them to add some custom R code at the bottom of the table’s R code properties to force the sorting to occur in the expected order.
R code was:
raw.data{noformat}
J
Jamie Morris
backlog
J
Jamie Morris
under review