Table toolbar
Last updated
Last updated
The table ribbon is divided into 8 sections based on the functionality provided. Let’s explore each of them.
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.
You can hide columns by selecting them and clicking on the hide icon. Enable columns from the series window.
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.
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.
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.
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.
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.
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.
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.
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.
Ranking: Rank your data by applying TopN rules. When hierarchical datasets are involved, you can apply nested ranking. Learn more about ranking.
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.
Blend: Analytics+ enables you to combine related measures into a single column using the blend option. Learn more about blending 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.
Calculated measures can also be created from the Pivot data window.
Annotations
With its annotation feature, Inforiver Analytics+ helps you capture perspectives, descriptive stories, and priorities in your reports. Learn more about annotations.
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.
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.
Synchronized scrolling
Analytics+ facilitates comparative analysis with synchronized horizontal & vertical scrolling. When you scroll through one trellis panel, the other panels scroll automatically.
Analytics+ has been designed to generate fully formatted, high-resolution PDF extracts.
The PDF export option is enabled in the service only. Exports are not supported on the desktop.
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.
Click the icon to maximize the formula editor. The maximized view is useful for entering large, complex formulae.
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.
