Q Research Software

The Ready-Made Formula function of Moving Average is in Q but not in Displayr.

Steps for replication: Open Q Add the attached dataset In the blue drop down select Brand Attitude Select Love and Like in the columns Right click and select Create NET Click on the blue arrow next to the blue drop down In the variables and Question tab right click and select Insert Ready Made Formula(s) >> Pick One - Multi → Pick Any (Flatten) Click on OK on the next popup Keep the selection on Rows and click on OK Double click on any row number to take you back to the Output page The output of the new table does not include the the Love +Like is not present create in step 5 (see attached picture) !image-20220214-210904.png|width=319,height=682! This is legacy feature which different to the QScript - Flatten Questions and maybe should point to the QScript rather than having two different options.

We have some Ready-made Variables and Calculations that do mathematical operations within variables (standardize, average, etc), but would be good to have the ability to provide a nominal or date grouping variable to do the same calculation on the same data, but by group. For instance, create a new variable that standardizes # hamburgers eaten by country rather than across all respondents.

A function for working out the median is not available in our mathematical formula functions.

A user has a list of zip codes that they would like to roll up into the associated MSAs. This would be a good use case for Ready Made New Variables > Automatically Combine Categories > By Geography , except that MSAs are not currently a geographic type of output. Instead, the user would need to build a custom QScript to do this for them.