Sign in
x
☰

Sorting responses

Updated at 2019-12-31 17:41:25 UTC
Data table showing responses to "Thinking about your Condition X patients, how many of those are currently receiving a GA (gamma antagonist)?" with the "Response" column header highlighted in a red box, displaying percentage results from 0 (5.0%) to "21 to 30" (5.0%).

You can quickly sort data within an element:

  • Press "Response" to sort by value
  • Press "#/%" to sort by frequency

This is only useful for sorting in ascending or descending order. If you want to use a non sequential sort order, customize "Sort as" in the Format dialog.

Sort by value

Press "Response" once to sort by value:

Expanded view of Q1 responses showing all nine categories from "0" to "100", with "1 to 10" having the highest percentage at 67.0% and several categories showing low percentages like 1.0% to 3.0%.

Note: If there are no changes, the default is already set to sort by value for that element (see JSON editor: type.)

Press "Response" again to reverse the sorting order:

Q1 responses sorted in descending order by percentage, starting with "71 to 80" at 2.0% at the top and ending with "0" at 5.0% and "N" (italicized) at the bottom.

Sort by frequency

Press "#/%" once to sort by frequency:

Q1 responses sorted with "1 to 10" (67.0%) at the top, followed by "11 to 20" (16.0%) and "0" (5.0%), showing a custom sort order with the highest percentages prioritized.

 Press "#/%" again to reverse the sorting order:

Alternative sort order for Q1 with "31 to 40" (1.0%) at the top, followed by "61 to 70" (1.0%) and other categories, ending with "1 to 10" (67.0%) and "N" at the bottom.

Sorting in compact groups

In compact groups, you can press "#/%" to sort by frequency.

Note: For compact groups, sorting by frequency does not save. If you close and reopen the project you'll need to press to sort again.

Multi-select question S10v1 asking "Which of the following therapies have you prescribed/recommended in the last 12 months for Condition X?" with "Compact to 1" view, showing 12 products sorted by percentage from "Product H" (79.0%) to "Product F" (7.0%).