Articles in this section

See more

How to Show a Specified Number of Rows and Keep Other Specific Rows in a Table or Visualization

  • Updated
Follow

This article describes how to go from a standard table...

Article 2 - Image 1.png

...to a table that only displays a specified number of rows from the top, plus any other specified rows:

Article 2 - Image 2.png

Requirements

  • A table or visualization in Displayr.

Note: You must apply the rule directly to the input table if you see a table icon in the Data > Data Source > Data field in the object inspector 26UI_ObjectInspector.png of a visualization.

TableInput.png

You will also see a warning in the Rules section of the object inspector 26UI_ObjectInspector.png if you have applied a rule directly to a non-compatible visualization, and you will need to apply it to the input table instead. For example:

RuleCannotBeApplied.png

Method

  1. Select your table or visualization.
  2. Go to Data > Rules in the Object Inspector 26UI_ObjectInspector.png.
  3. Select + > Rows/Columns > Show Only Top K and Specified Rows.
  4. Specify the Number of rows from the top to include.
  5. Enter the label of any Rows to always retain, e.g., Pepsi Max. It is important to match the spelling as it is displayed in the table.
  6. OPTIONAL: Select the Color for the required rows specified in step 5.
  7. Press OK.

Next

How to Use Rules in Displayr

Related articles