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.
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.
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.
Trellis
Series
Open the series configuration window to:
-> Set a custom width for your measures
-> Hide or display measures
-> Re-order measures
Split
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.
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.
Annotations
Templates
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.
You can copy the JSON config to the clipboard or export it as a file.
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.
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.
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.
When you have multiple measures in your report, you can display them in different tables with the split option.
Conditional formatting: Highlight your data instantly using Inforiver's built-in conditional formatting options. You can also specify custom conditional formatting rules. .
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.
Ranking: Rank your data by applying TopN rules. When hierarchical datasets are involved, you can apply nested ranking. .
Blend: Analytics+ enables you to combine related measures into a single column using the blend option. .
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 window.
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.
With its annotation feature, Inforiver Analytics+ helps you capture perspectives, descriptive stories, and priorities in your reports.
The Analytics+ visual is IBCS compliant, adhering to standardized IBCS design principles. The visual ships with integrated IBCS templates, you can instantly create an with in-built variance calculations in a single click. Regular rid templates are also provided.
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.