This article describes how to use a Control Box to select which rows or columns are shown in a visualization. The post contains the steps required to go from a page with a visualization showing data for all age groups...
...to a Page where the user can select which age groups (columns) to show based on a Control Box selection.
Requirements
- A Control Box control (see How to Create a Combo Box Filter or How to Create a List Box Filter).
- A Displayr Visualization, excluding Chart "with Test" Visualizations, or a table created using Table
> Paste or Enter Table.
- An above-mentioned output type with row/column labels matching the Item list or Items From field in object inspector of the Control.
Method
- Select your visualization/table and go to the object inspector > Data > Row Manipulations/Column Manipulations > Select Row/Columns to show by.
- Select Choosing from Combo Box or List Box control.
- In Row/Columns to show, select the Control Box you wish to use to select the data. Ensure that the Control Box list matches the labels used in rows/columns of your output/data source. In this example, the Control Box List contains the different Age groups as seen in the columns of the table below the visualization above.
Next
How to Filter Rows and Columns in Visualizations and Tables Without Code
How to Select and Order Rows or Columns to Show in a Visualization Based on a Calculation
How to Create a Combo Box Filter
How to Connect Filters to Controls Using R Code
How to Create a List Box Filter
How to Create a Text Box Filter
How to Create a Combo Box (Drop-Down Control) With a Dynamic List