Skip to main content

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 tab 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 is located to the right of the Tools panel and can be collapsed, hidden, or expanded.

Widgets panel

This panel can be used to:

The Widgets panel can be expanded or collapsed by clicking the arrows in the top right corner. It can be resized by dragging from the right edge.

Collapsing the widgets panel

The Widgets panel can be hidden by clicking the arrow at the bottom of the panel. It can be shown again by clicking the button attached to the bottom right of the Tools panel.

Hiding the widgets panel

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 drill down 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 drill down 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 chartsColumn chartsBar chartsPie chartsOther
Line chartStacked columnsStacked barsPie chartScatter plot
AreasClustered columnsClustered barsDonut chartRadar chart
Stacked areas100% stacked columns100% stacked barsWaterfall chart
100% stacked areasColumns and linesBullet chart
Gauge
Tree map