Table toolbar

The table ribbon is divided into 8 sections based on the functionality provided. Let’s explore each of them.

1. Style

• You can customize the look and feel of the report with the options in this section. Set the font style, size, color, and background fill. Select a row, column, or cell to enable the bold, italicize, underline, background, and font color options. Learn more about styling and formatting tables.

Applying font styles

• You can hide columns by selecting them and clicking on the hide icon. Enable columns from the series window.

Hiding columns

2. Alignment

This section provides options to:

• Arrange your data according to the content, based on the canvas, or fit the maximum possible data in the available space.

• Increase or decrease the padding between rows.

• Change the horizontal and vertical alignment of the content within a cell.

Learn more about styling and formatting tables.

Alignment options

3. Number

The number formatting section provides options to:

• Set the scaling factor (thousands, millions, billions, etc) at report level or measure/cell level for data with mixed granularities i.e. some of the data may have values in thousands and some values may be in millions.

• Express data such as rates as a percentage.

• Add a prefix/suffix.

• Specify the decimal precision.

In the example below, we have used the number formatting options to apply a scaling factor of millions, added a $ prefix, and increased the decimal precision of the relative variance. Learn more about number formatting.

Number formatting

4. Charts

With Analytics+, you can insert a row-level chart in a single click. All you need to do is, select the measure and choose the type of chart required for your data. Learn more about inline charts.

Inline charts

5. Category

• Trellis

In small multiples mode, you can customize the trellis layout. Click on the dropdown icon to apply a layout. You can add additional customizations by clicking Customize grid. Learn more about trellis customizations.

Trellis layouts

• Series

Open the series configuration window to:

-> Set a custom width for your measures

-> Hide or display measures

-> Re-order measures

Learn more about customizing measures.

Customizing measures

• Split

When you have multiple measures in your report, you can display them in different tables with the split option. Learn more about splitting and grouping measures.

Splitting measures

6. Data

• Conditional formatting: Highlight your data instantly using Inforiver's built-in conditional formatting options. You can also specify custom conditional formatting rules. Learn more about conditional formatting.

Conditional formatting

• Sorting: Sort your data based on measures or variances with options like ascending, descending, or Power BI native sort. Apply nested sorting or custom Excel-like sorting. Learn more about sorting options.

Sorting

• Ranking: Rank your data by applying TopN rules. When hierarchical datasets are involved, you can apply nested ranking. Learn more about ranking.

TopN

• Filter: After assigning visual measures and dimensions, instead of using Power BI filters, you can apply filters on your data from within the Analytics+ visual. Click the filter icon at the top-right corner to view applied filters.

Filter

• Blend: Analytics+ enables you to combine related measures into a single column using the blend option. Learn more about blending measures.

  

  Blend measures

  • Formula: You can create visual-level measures within the Analytics+ visual, without having to modify your data source. Click on the formula button to open the Calculated Measure side pane.

  • Type the '#' key to open the suggestions window and select measures.

  • Click the icon to maximize the formula editor. The maximized view is useful for entering large, complex formulae.
  • Calculated measures can also be created from the Pivot data window.

Creating a calculated measure

The new measure can then be assigned to the Actual or Comparison buckets and plotted like measures from the data source. Click on theicon from the pivot data window to modify the formula.

Created and plotted a formula measure

7. Story

• Annotations

With its annotation feature, Inforiver Analytics+ helps you capture perspectives, descriptive stories, and priorities in your reports. Learn more about annotations.

Annotations in Analytics+

• Templates

The Analytics+ visual is IBCS compliant, adhering to standardized IBCS design principles. The visual ships with integrated IBCS templates, you can instantly create an IBCS report with in-built variance calculations in a single click. Regular rid templates are also provided.

Templates

8. Actions

The actions section provides single-click options like

• Enable synchronized scrolling

• View shortcut keys and search for features

• Apply themes

• Enable or disable KPI

• Reset all configurations to default settings

• Open display settings.

Actions

Synchronized scrolling

Analytics+ facilitates comparative analysis with synchronized horizontal & vertical scrolling. When you scroll through one trellis panel, the other panels scroll automatically.

Synchronized scrolling

9. Exporting reports

Analytics+ has been designed to generate fully formatted, high-resolution PDF extracts.

PDF export option

The PDF export option is enabled in the service only. Exports are not supported on the desktop.

PDF export

10. Backup and restore

Analytics+ supports extensive customizations for every element. It also allows you to take a backup of the visual configuration and apply the same config to other visuals. You can import/export the visual configuration as a JSON file. The JSON file can be saved to your local system and shared with other users as well. Learn more about backup and restore.

You can copy the JSON config to the clipboard or export it as a file.

Backup and restore