A field's type, format, grouping, aggregation, and sorting shape how it behaves in widgets, and each can be edited.
This page explains how data items behave once they are placed into widgets. For how data is organised and structured across sources, see Data Setup.
Types and Formats Copy Link
Each data item in the Data Panel has a type and format that affect how it can be used and displayed. The data type determines what kind of data it contains, while the format determines how that data is displayed and processed in widgets.
Data Types Copy Link
AG Studio supports five core data types:
| Data Type | Icon | Description | Examples |
|---|---|---|---|
| Text |  | Letters, words, and alphanumeric characters | Country, Product Name, Status |
| Number |  | Integer or decimal values | Revenue, Quantity, Price |
| Boolean |  | True or false values | Is Active, Has Discount |
| Date |  | Calendar dates | Order Date, Delivery Date |
| Date Time |  | Calendar dates with time | Timestamp, Created At |
Formats Copy Link
A format controls how data is displayed in the interface. For example, a number might be displayed as 1,000, 1000.00, $1,000, or 100% depending on its format.
The following default formats are available in AG Studio:
| Data Type | Available Formats |
|---|---|
| Text | Text (default display) |
| Number | Integer, Decimal, Percentage, Currency |
| Boolean | Boolean (True/False) |
| Date | Date (e.g., 31/12/2025) |
| Date Time | Date Time (e.g., 31/12/2025, 13:00:00) |
The available formats and their display settings are configured by the application developer. Beyond the standard formats listed above, developers can also create custom formats tailored to specific business needs.
Format is a rendering option that affects only how values are displayed in a widget, it does not change the underlying data.
Editing Fields Copy Link
You can edit certain field properties directly in AG Studio when the developer has made the field editable.
Select a data field in the Data Panel to switch the Edit Panel to its data-field view, where you can see the field's properties. When the field is editable, an Edit button appears at the bottom of the panel. Select Edit to enter edit mode, then Save to apply your changes or Cancel to discard them.
You can edit the following properties when a field is editable:
| Property | Editable |
|---|---|
| Field ID | No |
| Calculation Type | No |
| Format Type / Number Subtype | No |
| Name | Yes |
| Description | Yes |
| Formatting Options | Yes, within the configured format type |
As you adjust formatting options, a live preview in the panel shows how your values will be displayed. For the format string syntax used by custom format overrides, see Formatting.
Grouping Copy Link
When a field is placed in a category slot in a Widget, or added as a column in a table, it is used as a Group by. This returns the unique values from that field and uses them to define the groups across which values are aggregated. For example, placing Region in a category slot groups the data so that each region appears as a distinct row or segment in the widget.
Group by is available on columns and calculated columns. It is not accepted in the value axis of visualisations.
Aggregation Copy Link
Aggregation defines how values are combined when a Widget summarises data across multiple rows. By default, AG Studio applies an aggregation when data is added as a widget value. The aggregation can be changed from the data pill menu. Available aggregations depend on the data type and input requirements.
Aggregation can be applied to columns and calculated columns. Measures are pre-aggregated and do not support additional aggregation.
| Name | Short Label | Description |
|---|---|---|
| Sum | (sum) | Adds all values together. |
| Average | (avg) | Calculates the mean of all values. |
| Minimum | (min) | Returns the smallest value in the result set. |
| Maximum | (max) | Returns the largest value in the result set. |
| Count (Distinct) | (countd) | Counts the number of distinct values in the result. |
| Count | (count) | Counts the number of rows included in the result. |
| First | (first) | Returns the first value in the grouped result, based on the current data order. |
| Last | (last) | Returns the last value in the grouped result, based on the current data order. |
Aggregated values respond to category grouping changes. For example, adding Region as a category to Total Sales produces total sales by region.
The following example demonstrates how aggregation responds to different category groupings. Using the Line Net calculated column, both tables apply two different aggregations: Average and Sum. The first table groups by store region and the second by customer segment. Notice how both the sum and average values change as the grouping categories change, illustrating how the same aggregation functions produce different results depending on the data grouped.
Sorting Copy Link
The sort order can also be changed from the data pill menu. Sort options include None, Ascending, and Descending. Each Widget can have one sort applied.