Treat date variables as categorical
backlog
M
Mattias Engdahl
Merged in a post:
More control for date variables when showing or hiding periods
N
Neon carrot Coral
When a filter is applied to a table with a
Date/Time
variable, the empty periods don’t show:!_name=image (f32cf033-c85a-4154-bf3f-7c34f6e90fe3).png|width=1074,height=286!
However, if we replace the
Date
format variable with a categorical or Pick One
variable, the columns that have their sample filtered out will appear, like this (February and December are now both here), but showing as empty because of the filter:!_name=image.png|width=100%!
There should be better control of data variables regarding how they show or hide to remove any inconsistencies.
M
Mattias Engdahl
Merged in a post:
Add Ready-Made New Variable Functionality to Convert a Date Variable to Nominal Variable
C
Cristin McCurdy
Allow users to create a nominal variable from a date/time variable via the ready-made new variables menu, bypassing the need for them to use R code. They can then use this nominal variable in filters or anywhere else in their analyses where a date/time variable is not appropriate.
You could have them select the date/time period aggregation level in a prompt and then perform the conversion, rather than having them remember that they need to do it directly in the date/time variable upfront.
I’m tired of remembering how to do this/finding the help article with the info myself when I haven’t had to do it in a while. Yes, I know it’s simple R code.
This applies to both Displayr and Q.
J
Jamie Morris
backlog
J
Jamie Morris
planned
J
Jamie Morris
under review