About widgets

Widgets are the building blocks of dashboards. They allow you to organize, view, and derive meaning from your data. Widgets can be sorted or filtered, and switched between different types. You can turn on real-time to ensure a widget always has the latest data updates. You can also share widgets with others in your organization so they can add them to their own dashboards, or export the data to CSV. You can use the style editor to modify the appearance of a widget, for example change the colors of table cells or chart traces.

Widgets panel

The Widgets panel contains all of the available widgets in your application. It can be opened by choosing Widgets from the Insert menu in the application header, or by using the keyboard shortcut W.

The widgets panel has two tabs, Widgets and Saved widgets.

The Widgets tab can be used to:

• Add new widgets.
• Switch the type of a widget.

The Saved widgets tab can be used to:

• Add saved widgets.
• Rename, share or delete saved widgets.

Types of widgets

Many different types of widgets are available in the application. The majority are used to visualize data, for example, a Pivot table or a Line chart, but some widgets also provide extra controls or information for the user, for example, the Text editor.

note

Widgets are plugins, so your application may not include all of the widget types listed here. If you cannot find a specific widget type in your Widgets panel, contact your system administrator.

Tables

There are different types of table widgets available in the application.

• Pivot table
• Tree table
• Table
• Drillthrough table

A Pivot table displays aggregated data, structured in a tree and organized as logical hierarchies and levels. It allows you to expand and collapse level members to reveal their subtotals and children.

A Tree table is similar to a pivot table, but the columns of its row header are condensed into a single column, displayed as a tree.

A Table is more suited to displaying flat data and it does not have the expand/collapse functionality. The Table has a breaking sort, meaning when a sort is applied the members in a column are sorted without regard to the hierarchy, whereas Pivot tables and Tree tables have a non-breaking sort, see sort data.

The Drillthrough table displays all the underlying facts (also referred to as records or contributors) that contribute to a specific cube location. See the Microsoft documentation for more details.

KPI widgets

KPI widgets allow you to see the values of high level indicators at a glance.

There are two types of KPI configurations:

• KPI - shows the totals for the members of the added hierarchy for each added measure.

• Comparison KPI - enables you to compare values for 2 members from the same hierarchy. For example, you could choose to compare values for USD and GBP from the Currency hierarchy.

Charts

Atoti UI uses Plotly charts for chart based data visualization. The available Plotly charts are :

Line charts	Column charts	Bar charts	Pie charts	Other
Line chart	Stacked columns	Stacked bars	Pie chart	Scatter plot
Areas	Clustered columns	Clustered bars	Donut chart	Radar chart
Stacked areas	100% stacked columns	100% stacked bars		Waterfall chart
100% stacked areas	Columns and lines			Bullet chart
				Gauge
				Tree map