Sorting Reports by Measures

In Infinity Analytics, the report table is always sorted by a single measure.  By default, data in the report table is sorted based on the first measure and in descending order with the highest measure values at the top of the table.  The sort order can be either descending or ascending by any measure of your choosing.

To sort by a measure

  • Click the up/down icon, Help_sorting_overview_icon_2, next to the measure name

To change the sort order

  • Click the up or down arrow icon, Help_sorting_overview_icon_1, next to the measure name that’s currently being sorted

In this example, the report is sorted by the Sessions measure in descending order.  To sort by the Users measure, click the up/down icon, Help_sorting_overview_icon_2, in the Users cell.  To sort Sessions ascending, (with lowest values at the top), click the down arrow icon, Help_sorting_overview_icon_1, in the Sessions cell.

Help_sorting_overview_1

Sorting Reports with Multiple Dimensions

Sorting works the same way whether the report table has one dimension or many.

  • The first dimension is always the primary dimension that will be sorted.
  • Each successive dimension is also sorted in the same order as the first dimension.  For example, in the table below, two dimensions are present: Operating System Name and Browser Name.  Operating System Name is the primary dimension and is sorted first.  Then for each operating system, the Browser Name is sorted.
  • Each dimension is sorted against its siblings only.  For example, in the table below, Windows 7 > Chrome is sorted against Windows 7 > Firefox and thus is second.  However, neither are sorted against Mac OS X > Safari since they do not have the same primary dimension.

Help_sorting_overview_2