Inforiver
Analytics+
Analytics+
  • Introduction to Analytics+
    • Installing Analytics+
      • Install for yourself
      • Installing from AppSource
      • Installing for your organization
    • Licensing and manual renewal
  • Working with Analytics+
    • 1. Navigating the Analytics+ toolbar
      • Chart toolbar
      • Card toolbar
      • Table toolbar
    • 2. Data Management
      • Advanced pivot
      • Adding calculated measures
    • 3. Charts
      • 3.1. Charts - getting started
      • 3.2. Quick options - charts
        • X-axis customizations
        • Y-axis customizations
      • 3.3. Configure measures for charts
      • 3.4. Configure dimensions for charts
      • 3.5. Chart discoverability
      • 3.6. Data label customizations
      • 3.7. Deviation
      • 3.8. Display settings for charts
        • Charts - canvas settings
        • Charts - axis settings
        • Charts - number settings
        • Charts - legend settings
        • Charts - other settings
          • Charts - tooltip settings
    • 5. Cards
      • 5.1. Cards - getting started
      • 5.2. Quick options-cards
        • KPI customizations
        • Chart customizations
      • 5.3. Configure measures for cards
      • 5.4. Configure dimensions for cards
      • 5.5. Insight charts
      • 5.6. Variance customizations
      • 5.7. KPI containers
        • Working with Groups
        • Working with Flex components
      • 5.8. Inserting formulas & text
      • 5.9. Card customizations
      • 5.10. Display settings for cards
        • Cards - canvas settings
        • Cards - number settings
        • Cards - legend settings
        • Cards - axis settings
        • Cards - other settings
          • Cards - tooltip settings
    • 6. Tables
      • 6.1. Tables - getting started
      • 6.2. Quick options - tables
      • 6.3. Configure measures for tables
      • 6.4. Configure dimensions for tables
      • 6.5. Formatting data
      • 6.6. Number formatting
      • 6.7. Inline charts
      • 6.8. Blend measures
      • 6.9. Row gripper options
      • 6.10. Display settings for tables
        • Tables - canvas settings
        • Tables - number settings
        • Tables - other settings
          • Tables - tooltip settings
    • 7. Trellis customizations
      • Charts trellis layout
      • Cards trellis layout
      • Tables trellis layout
    • 8. Customize measures
      • Charts measure series
      • Cards measure series
      • Tables measure series
    • 9. Splitting and grouping measures
      • Splitting and grouping: charts
      • Splitting and grouping: cards
      • Splitting and grouping: tables
    • 10. Conditional formatting
      • One-click rules
        • One click rules for charts
        • One click rules for cards
        • One click rules for tables
      • Configuring rules
        • Configuring rules for charts
        • Configuring rules for cards
        • Configuring rules for tables
        • Variable conditional formatting rules
        • Applying conditional formatting rules
      • Setting color scales
      • Managing rules
    • 11. Sort & Reorder data
      • Sorting data
      • Advanced sorting
      • Reordering data
    • 12. Ranking data - TopN
      • Ranking for charts
      • Ranking for cards
      • Ranking for tables
      • Dynamic ranking with numeric parameters
    • 13. Adding notes
      • Notes for charts
      • Notes for tables
    • 14. Data selection
    • 15. Working with hierarchies
      • Hierarchies in charts
      • Hierarchies in cards
      • Hierarchies in tables
      • Unbalanced hierarchies
      • Single child hierarchies
    • 16. Summary tables
    • 17. Backup and restore
    • 18. Context awareness
    • 19. Image support
      • Images in cards
      • Images in tables
    • 20. Analytics
      • Reference line
      • Reference band
      • Error bar
      • Trend line
      • Additional series
    • 21. Keyboard shortcuts
    • 22. Reading view access
    • 23. Row aggregation
  • Storyboard
    • Element customizations
    • Board customizations
    • Working with textboxes
    • Uploading images
    • Using shapes
    • Inserting slicers
    • Element interactions
    • Layers
    • Navigation
      • Play axis
    • Annotations
  • Gantt chart
    • Gantt: Canvas settings
      • Gantt: General settings
      • Gantt: Column settings
      • Gantt: Grid settings
      • Gantt: Timeline settings
    • Gantt milestones
    • Gantt: Data label settings
    • Gantt: Conditional formatting
    • Gantt: Web URLs
    • Gantt resource
    • Gantt: Zoom levels
  • Quick charts
    • Waterfall charts
    • Marimekko
    • Column/Bar charts
    • Bullet charts
    • Area charts
    • Pie charts
    • Treemap charts
    • Radar/Polar charts
    • Funnel charts
    • Sunburst charts
    • Bubble charts
    • Boxplots
    • Histogram
    • Gauge
    • Storytelling charts
      • Range charts
      • Ribbon chart
      • Tornado chart
      • Multi-variate charts
      • Sankey charts
    • Combo charts
  • Release notes
    • Analytics+ April 2025 update - Release 4.7
    • Analytics+ March 2025 update - Release 4.6
    • Analytics+ January 2025 update - Release 4.5.
    • Analytics+ January 2025 update - Release 4.3
    • Analytics+ November 2024 update -Release 4.2
Powered by GitBook
On this page
  • 1. Axis-level ranking for charts
  • 2. Row/column level
  • 3. Trellis level
  • 4. Nested rules
  • 5. Others group configurations
  1. Working with Analytics+
  2. 12. Ranking data - TopN

Ranking for tables

PreviousRanking for cardsNextDynamic ranking with numeric parameters

Last updated 1 year ago

Let's look at the different options to rank the data in your tables.

1. Axis-level ranking for charts

Let's look at the TopN configurations required to display the months with the least and most revenue in 2024. You can rank the axis categories based on the measures or variances.

After applying the TopN rule, only the 3 top-performing and bottom-performing months are rendered based on the variance.

2. Row/column level

In trellis mode, you can rank the data in the rows and columns. We can assign Top N rules at row x column level. Let's create a trellis depicting the sales actuals for product sub-categories across sub-regions and display panels based on their rank.

The regions and product categories are displayed based on the TopN rules:

3. Trellis level

You can apply ranking for linear trellises, where the row and column categories have been combined. To create a linear trellis, open the Pivot data interface > Category tab > Enable the Combine row/column dimensions option.

The TopN interface will have a Trellis tab from where you can set ranking rules. The TopN rules would display an overall ranking across row and column dimensions based on measures or variances.

The top-performing and bottom-performing panels are displayed after the ranking is applied.

4. Nested rules

When the dataset is hierarchical, we can apply nested rules to identify the top-performing or least-performing categories. Consider that we have a product and region hierarchy. Let’s explore the rules that need to be configured to identify the following trends:

  • Region and Category having the highest sales.

  • Top 2 Subregions that have the highest allocated budget.

  • Top 3 Subcategories that have the highest variance percentage.

Only one rule can be created per level of the hierarchy.

STEP 1: Create a row-level rule to identify the region with the highest sales.

STEP 2: Create and apply another row-level rule to identify the Subregions with the highest budget. As Subregion is at the lowest level of the region hierarchy, notice that the ‘Add new rule’ link is disabled.

STEP 3: Add a column-level rule to identify the category with the highest sales.

STEP 4: Add another column-level rule to identify the Subcategories with the highest variance percentage.

After applying the Top N rules discussed above, the chart is rendered as shown below.

5. Others group configurations

You can group the remaining items that do not fall in the Top N buckets and display them in the report. To achieve this, check the ‘Show remaining items as’ box.

6.1. Rename the ‘Others’ bucket

Let's assign a relevant name for the items grouped under ‘Others’. In this example, we are displaying the top 8 months which had the maximum sales. We've renamed the Others bucket to "Rest of the year".

6.2. Add suffixes – Field name and count

You can suffix the name of the dimension category and the count of items grouped under the Others bucket by checking the relevant option:

  • Other + Category Suffix

  • Others + Item count

The number of items grouped under the ‘Others’ bracket is displayed by default for axis-level ranking. We'll display the category alone by unchecking the "Others + Item count" and selecting the "Other + Category Suffix" option.

6.3. Maintain sort order

Generally, the Others group is placed at the end of the section, after all the items that qualify for the Top N rule. You can select the ‘Maintain sort order’ option to arrange the panels based on the measure values.

To demonstrate this option, let's change the axis category and set the top N ranking to 2. Notice how the Others bucket is placed between the soda and juices categories as per descending alphabetical order.

TopN ranking for tables
Ranking applied for axis categories based on the variance.
Ranking a small multiples table by row and column dimensions
Ranking applied for small multiple tables
Trellis ranking interface
TopN ranking applied
Rule to identify region with the highest sales
Rule to identify subregions with highest plan
Rule to identify cateogry with the highest sales
Rule to display subcategories with highest relative variance
Nested ranking
Show remaining items as option for axis-level ranking
Others category renamed to Rest of the year
Dimension category as suffix
Maintaining sort order for axis ranking