Displayr

for instance - we have rules for blanking/or replacing low sample sizes with text, but not keep the sample size, but flag with an asterisk.

add rule to blank cells if not significant

Currently, there is a rule in the OneNote library that USE maintains with rules that we’ve written for users but haven’t been added to the online library (in both Q and Displayr) that highlights cells with any column comparison results in them. A rule that does something like this should be added to the online library in both Q and Displayr. The code for the rule is below: Highlight cells with column comparisons {noformat}includeWeb("Table JavaScript Utility Functions"); if (table.availableStatistics.indexOf("Column Names") == -1) form.ruleNotApplicable("column comparisons not available on this table"); form.setSummary("Highlight comparisons"); var high_label = form.newLabel("Color results:"); var high_color_picker = form.newColorPicker("hcolor"); high_color_picker.setDefault("YellowGreen"); high_color_picker.lineBreakAfter = true; var do_below_box = form.newCheckBox("dbb", "Highlight Statistics - Below"); form.setInputControls([high_label, high_color_picker, do_below_box]); var high_color = high_color_picker.getValue(); var testing_results = table.get("Column Comparisons"); var cell_colors = table.cellColors; // Color main table for (var row = 0; row < table.numberRows; row++) { for (var col = 0; col < table.numberColumns; col++) { var current_cc = testing_results[row][col].toUpperCase(); if (current_cc.match(/[A-Za-z]+/)) { cell_colors[row][col] = high_color; } } } table.cellColors = cell_colors; // Do below table as well if it exists if (do_below_box.getValue() && belowTableExists() && below_table.statistics.length > 0 && below_table.availableStatistics.indexOf("Column Comparisons") > -1) { var testing_results = below_table.get("Column Comparisons"); if (testing_results.length == 1) testing_results = testing_results[0]; else testing_results = testing_results.map(function (a) { return a[0]; }); var cell_colors = below_table.cellColors; var colors_transposed = cell_colors.length > 1; for (var col = 0; col < table.numberColumns; col++) { var current_cc = testing_results[col].toUpperCase(); if (current_cc.match(/[A-Za-z]+/)) { var row_index = colors_transposed ? col : 0; var col_index = colors_transposed ? 0 : col; cell_colors[row_index][col_index] = high_color; } } below_table.cellColors = cell_colors; }{noformat}

Sometimes users show top 10 items in one chart and bottom 10 items in another. Can we have a Rule for Bottom X charts. Maybe even for ‘from - to’ rule. E.g. Show rows ranked 10th to 19th.

We have a Rule allowing users to Move Net Row to the Top. With the new Rule allowing us to Sort Column it would be useful to also move NET (or TOTAL) to the front of the table Example, you want to sort a Table by Columns but show NET (or TOTAL) as the first column.

More specifically, the user would like to be able to hide/replace NAs when appearing in tables in Explore mode.

Currently the rule Modify Headers > Automatically Remove NETs from Table does not work if the table columns contain spans

In this case, the user was sorting rows in ascending order and wanted to anchor “Other” at the top of the table, rather than at the bottom. They ended up having to move the NET to the top (via Move NET to top rule) and force “Other” to appear after NET using the “Make one row appear after another” rule. User would like to explicitly specify which row to anchor at the top (or bottom). !image-20230324-202722.png|width=861,height=385!

It currently offers the ability to sort by Largest Column, Last Column, or a Chose a column. I would like have added sort by first column. We often want to sort by the first column and sometimes that column is the first column but has a different name. If we utilize Choose a column name it will not be able to find the column name for different tables, or worse if you edit the label of the column the rule will fail silently.