Sorting Dashboard Data Columns

InetSoft's award-winning dashboard software allows users to merge, sort and filter complex sets of data into viewer friendly formats like data columns. View the example below to learn more about the Style Intelligence solution.

Any column in a table can be sorted in ascending or descending order. You can sort the table data based on a single column, or specify nested sorting columns. If a column in the table is already sorted, sorting on a new column clears the previous sorting.

To sort a single column, do one of the following:

  • Click the 'Sort' button in the column header. This sorts the column in ascending order. Click the button again to sort the column in descending order. Click a third time to return the column to its original order.
  • Right-click the table header and select the 'Sort Column(s)' option. This opens the 'Sort Column' dialog box, where you can specify the sort order for the selected column.

When a column is sorted, its sort order is indicated by the small arrow next to the column name in the column header cell.

#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index Read More

To sort multiple columns in a hierarchical fashion, follow these steps:

  1. Right-click the table title row, and select 'Sort Column(s)' from the context menu. This opens the 'Sort Column' dialog box.
  2. From the 'Sort on' drop-down menus, select the table columns that you wish to sort.
    • The hierarchical sort order of a column is determined by the vertical position of the menu. The column specified in the top menu is sorted first, the column specified in the second-to-top menu is sorted sec­ond, and so on.
  3. For each column, select the 'Ascending' or 'Descending' button to determine the sorting direction.

When a column is sorted, its sort order is indicated by the small arrow next to the column name in the column header cell.

More Articles About Dashboarding

Air Quality Analytics - Air quality management and monitoring have become critical. Air quality dashboards, which provide data and insights on the condition of our atmosphere in real time, have become very useful tools with the emergence of smart technology. This article explores the complex world of analytics and Key Performance Indicators (KPIs) used on air quality dashboards, providing insight into the measures and metrics that inspire decisions for a healthier, cleaner atmosphere. The monitoring of particulate matter concentrations is the central component of any air quality dashboard. Particulate matter, or PM for short, is the term used to describe minute particles or droplets in the air that may enter the lungs by inhalation. The concentrations of these different sized particles are important markers of the quality of the air. PM1, PM2.5, and PM10 KPIs are often used to measure PM concentrations...

Digital Experience Platform Dashboard Example - Success on your website or application depends on your ability to comprehend user behavior and engagement. Digital Experience Platforms, or DXPs, are now considered to be very effective tools for managing and improving an organization's online presence. DXPs deliver significant insights via dashboards that show KPIs and statistics. This article discusses KPIs and analytics on digital experience platform dashboards and the metrics and data points used to assess and enhance digital experiences. Any digital experience revolves on user engagement, and DXPs assist businesses in measuring it successfully. Typically, DXP dashboards incorporate the following KPIs to evaluate user engagement...

How to Make a Wind Rose Chart in InetSoft - There is no built-in chart type for a wind rose; however, since a wind rose is essentially a stacked bar chart bent into a circle, it is possible to obtain this display by applying a small script to an existing stacked bar chart. Begin by importing the data set into a Data Worksheet. The sample data we use here is from Iowa Environmental Mesonet and has this form: Wind direction data table The arrangement of the wind speed ranges as separate columns is inconvenient for making a stacked chart, so in the Import dialog box, enable the Unpivot Data option. This creates a Dimension column containing the speed ranges and a Measure column containing the percentages...

Live Airport Delay Information Dashboard - If you're looking for an Airport Delay Information Dashboard, InetSoft provides the perfect solution. As flights are constantly being delayed and/or changed, it's critical for users to have the most up-to-date information available as any delay in information access can result in missed flight. At InetSoft, we make sure to provide information that is fast and reliable to the frequent or even casual travelers across the United States. With tools to create a simple and aesthetic visual of airport delays and the weather information of airports across the country, information is constantly being updated automatically from live FAA data for an easy, conveniently amassed view for travelers...

Tool to Make a Heat Map Online for Free - To easily and quickly create heat maps online for free, create a Free Individual Account on the InetSoft website. You will then be able to upload a spreadsheet data set. choosing dashboard source Once you have done that, you will be able to proceed past the Visualization Recommender, which can usually get you started creating a dashboard. Since the Recommender does not allow you to create a heat map chart, press the Full Editor button. Then proceed to build the map as described in the previous section...

Previous: Merging Dashboard Tables
We will help you get started Contact us