Displayr

Desired Feature Be able to customize the label format of Date/Time variables shown in Displayr. More detail We need the ability to customize the labeling of Date/Time variables in Displayr. Right now we can do this in R, but the final variable Structure is a Nominal variable - which is not compatible with statistical testing that compares each period to the previous one. For example, instead of showing Jan-Mar 20, the user wants to label this and other quarters: Q1 2020. And also, use the compare to previous period setting on stat testing. Right now, the workaround is to relabel the dates using R, but then the user is limited to creating tables that work well with R (no spans, no arrows, etc). This request will reduce the extra outputs that users need to make (and may potentially slow down documents) and reduce custom R code that the user has to use, making the software feel more point and click.

Need text → date/time variable widget/automation. User can provide a format that the data is in YYMMDD or whatever and then the code can be auto-generated for the new variable and that variable turned into a Date/Time variable. Code used for this was: as.Date (strptime(ResLastCallDate,"%Y%m%d"))

This request is to treat Date/Time variables as categorical, so this allows sorting, reversing, hiding, moving and so on.

Ability to specify a relative period within the Contract Period variable For example, instead of selecting a specific month, the user could select: Date Aggregation = Month Compare Last Month Versus Last Month - 1 We could take it a step further and allow for a ‘Period Type’ option that would let the user to pick between Fixed (as it is now) and Relative (Last Month, Last Month - 1, etc ) Oliver has done something similar with the Difference between Columns Rules.

Allow uses to select the format in which the Date/Time variable appears. The default is the US setting (MM/DD/YYYY); however, non-US users would prefer DD/MM/YYYY or alternative settings (MM/DD/YY....)

On a date variable when you use the week aggregation the default is to have the week start on a Monday and end on Sunday. I have been asked a few times to have the ability to customize when a week starts and ends. The customer would like to have the ability to select when a week start as an example, to have the week start on a Sunday and end on a Saturday.

The user would like to set certain time periods to Missing when working with a Date/Time variable. For example, he wants to use a variable in the crosstab but doesn’t want 2020 to appear as it has no data. This way, he could also sig test 2021 to 2019 - the previous period with data. Workaround: change var to Nominal, but then the sig testing functionality isn’t the same:

Currently Date variables in Displayr and Q are always sorted from oldest to newest (left to right) when used as columns. But this isn’t always how users want to represent the data, some want to view it from newest to oldest or alternative sorting methods. Regular variables can be manually re-sorted but dates can’t. Allowing users to manually sort date variables or even just allowing them to flip the sorting would add functionality both products currently lack.

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: {noformat} raw.data [,2]= as.Date ( raw.data [,2],format="%m/%d/%Y") raw.data {noformat}