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. Edit
  • 2. Add calculated row
  • 3. Skip row
  • 4. Skip and hide row
  • 5. Disable suppress nulls
  • 6. Add template row
  • 7. Invert row
  1. Working with Analytics+
  2. 6. Tables

6.9. Row gripper options

Previous6.8. Blend measuresNext6.10. Display settings for tables

Last updated 10 months ago

You can use the row gripper for operations like editing categories, hiding rows, excluding rows from calculations, inverting rows, etc.

1. Edit

You can edit category names from within the Analytics+ visual. The category becomes modifiable when you select the Edit option from the row gripper.

You can choose from the recommended date formats when you have a date dimension in your axis. Click on the row gripper and click edit to view the supported formats.

2. Add calculated row

You can create calculated rows and seamlessly insert new categories at the visual level without modifying the underlying dataset. Use the # symbol to refer to a category. To refer to a particular cell within the formula, click and select the cell - the reference to the cell will be populated automatically.

3. Skip row

You can exclude rows from calculations but still display them in your tables with the Skip row option.

In the example, notice how the row total changes after skipping the February row.

Select the Unskip row option from the row gripper to include a skipped row again.

4. Skip and hide row

You can remove a row from the report altogether with the Skip and hide row option. You are effectively performing a soft delete.

To display hidden rows again, select the Reset skip & hide rows option

5. Disable suppress nulls

Null rows are automatically hidden. To display the rows containing null values for all measures, select the Disable suppress nulls option.

Notice how the Depreciation accounts are displayed only when the Disable nulls option is enabled.

Select Enable suppress nulls from the row gripper to hide rows with nulls for all measures.

6. Add template row

You can insert calculated rows at each level of a row hierarchy in a single shot with the template row option.

STEP 1: Select the row in which position the template row should be inserted and choose the Add template row option from the row gripper.

STEP 2: Enter the calculation and click Create. Notice how the Juices Enhc row is created for every region in one shot.

You can choose to insert the template row above or below the selected source row with the Position option.

To edit or view the calculation for a template row, click the row and choose the Edit template row option.

To delete a template row, select the Delete template row option.

7. Invert row

You may need to flip the signs at the visual level, for instance, when your reports contain data for loans or depreciation. You can multiply an entire row by -1 with the Invert row option. Notice how the Mineral Water row has been inverted

Select the Revert inverted row option from the row gripper to restore the original row.

For complex, multi-line formulae, you can maximize the formula editor by clicking the icon.

Row gripper for tables
Editing categories
Date formatting options for axis
Creating a calculated row
Maximise formula editor
Totals before skipping Feb row
Totals after skipping Feb row
Totals before hiding the February row
Categories and totals after hiding Feb
Restoring hidden rows
Disable suppress null option
Depreciation accounts displayed
Template rows created for each region
Juices Enhc template row insrted below the Juices row
Edit template row
Invert row option
Mineral water row inverted