IBM Accelerator Catalog
IBM Accelerator Catalog

How to sort one column based on values in another column

This document will demonstrate how to sort months in the correct chronological order.

Slide Two

About this accelerator

In a data module, suppose you have a column for Month. If you simply drop that column onto a Line visualization on a dashboard, by default the months will be sorted alphabetically. If you would like to display the months in chronological order, you can sort the Month column by another column (e.g. Month Number).

Additional details

  • Accelerator typeHow to
  • IndustryAny
  • Business functionAny
  • Product and version Cognos Analytics - 11.2.0 to Current
  • Author typeIBM
  • Company nameIBM
  • Author name IBM
  • Last modifiedMay 19th, 2021
  • Language English