Skip to main content

What’s New

Qrvey 9.0
Qrvey Version 9.0 is now available! This release introduces multi-platform hosting (Azure & AWS), a redesigned Dashboard, extensive widget customizations, and numerous features, enhancements, bug fixes, and performance improvements.
Learn More
Qrvey 8.8
Qrvey Version 8.8 (LTS) is now available to customers! This version supports FIPS for GovCloud and includes tons of bug fixes and performance improvements.
Learn More
Qrvey 8.7
Version 8.7 of the Qrvey platform is now available to customers! This version includes new features including area charts, the ability to pivot and export data, as well as numerous bug fixes and performance improvements.
Learn More
Qrvey 8.6
Version 8.6 of the Qrvey platform is now available to customers. This version includes several new feature enhancements and performance improvements.
Learn More
Required Update for 8.5.1
Attention 8.5.1 customers: for any 8.5.1 instance deployed prior to 08/05/2024, an update is required to ensure you are running the latest images.
Learn More
Qrvey 8.5
Version 8.5 (LTS) of the Qrvey platform is now available to customers. This version includes several new features and performance improvements.
Learn More
End-of-life Schedule
We've added a new article that lists the features and endpoints that have been scheduled for deprecation. All features and endpoints will be supported for (1) year after the release date of the LTS version that contains the alternative.
Learn More
Version: 9.0

Sorting

sorting-data

There are several ways to sort data (by ascending or descending values) within the Chart Builder. By default, most charts sort data by the grouped column in ascending order.

Details​

  • XY Charts (e.g., Bar, Line, Symbol, Multiseries, etc.) that use one grouped Category and one aggregated Value column can be sorted by either the Category or the Value, but not both simultaneously.
  • Multiseries Charts can also be sorted by either the Category or Value column, while the Series column can be sorted independently at the same time.
  • Tables can be sorted by one or more columns. Sorting by multiple columns allows you to first sort by one column, followed by the sorting logic of the next column. For example, sorting by Country and then City. You can also sort on columns that are not visible in the table, listed under Other Columns.

Table Sorting

  • Crosstab Charts can be sorted by both "parent" and "child" columns.

Crosstab Sorting

Charts​

Chart Sorting

If configured under Chart Configuration > Self-Service, certain charts allow sorting.

The Column Pill​

Pillbox Sorting

Click the three-dot menu in a field's pillbox. By default, column pills display their sorting direction using an arrow. Columns used in Tables and Crosstabs also support removing sorting to produce an unsorted dataset. The Clear Sorting option is accessible from the same menu in the column pill of these charts.

The Configuration Panel​

Config Panel Sorting

For chart types that support this method, a Sorting section appears in the configuration panel. This section includes a dropdown list of all columns in the dataset, with the selected option representing the column (or aggregated column) used for sorting.

Using this dropdown, you can select a column to sort by, even if the column is not used in the chart. Columns included in the chart are listed separately, along with their role in the visualization. The ability to sort by an unused column makes this the most flexible sorting method.

The General Section in the Config Panel​

Some charts also support sorting through icons within Configuration Panel > Sort by > General subsection.

  • ABC icon: Sorts data by the category column.
  • 123 icon: Sorts data by the value column.
  • Direction icons toggle between ascending and descending order.