The Analysis Grid for End Users
The Analysis Grid has its own user interface that allows you manipulate data, create charts, change table layouts, and much more, at runtime.
The following topics introduce Logi Info end-users to the Analysis Grid:
- Selecting Data
- Adding Formula Columns
- Filtering Rows
- Showing, Hiding, and Moving Columns
- Sorting Rows
- Grouping Rows
- Creating Aggregations
- Creating Custom Aggregations
- Controlling Paging
- Formatting Data
- Creating Charts and Gauges
- Editing Chart Labels and Captions New for 14.1
- Pivoting and Summarizing Data
- Zoom Control
- Exporting Data
- Adding Analysis Grid Charts to Dashboards
Information for developers is available in The Analysis Grid for Developers.
About the Analysis Grid
The Analysis Grid user interface consists of separate panels for controls, tables, and visualizations. At runtime, you can manipulate the controls, creating data analyses and visualizations on the fly. The Analysis Grid below displays both a chart and table:
As you can see in the examples below, the Analysis Grid can look quite different depending on the Theme being used. The examples in this topic use the Signal Theme.
The Analysis Grid consists of a set of panels. The Controls Panel, at the top, includes a set of tabs or buttons that allow you to manipulate the data and visualizations at runtime. The visibility of specific controls is configured by the application developer and so you may or may not see the full set shown here.
When a tab or button is clicked, a configuration panel for that feature appears, as shown abelow. Clicking it again hides the panel.
Visualization Panels contain either a Data Table, Crosstab Table, or chart. Panels can be collapsed or expanded using the "+" and "-" icons. You can also rearrange their order by clicking with your mouse near the top of a panel, and dragging it up or down.
Panels containing tables may display an icon for exporting them to Excel, CSV, or PDF. The availability of the different types of exports is under developer control, so those available to you may vary.
Clicking a panel's gear icon will display a configuration area for the specific visualization. The Table configuration area, shown below, allows you to control a variety of table features.
Table column headers contain a variety of features. They can be dragged to rearrange the column order or to adjust column widths. When column header text is clicked, drop-down menus provide sorting, filter, formatting, grouping, and other features, as shown below. The availability of each feature can be restricted during development.
If your application has been configured for it, Undo and Redo icons also display on the Control Panel, circled below. These allow you to undo and redo your recent actions.
Additionally, if your application has been configured for it, a Pause Data Retrieval button displays next to the Control Panel. When clicked, it temporarily halts data retrieval from the server. This feature is useful when data retrieval is slow and you prefer to make several changes to the Analysis Grid without having to wait for data after each change.
Click the Resume button, shown below, to resume retrieval.
New for 14.2 Depending on your application's configuration, this feature may be enabled by default. As always, you can select Resume to retrieve data results.