Fields and metrics

With Data Manager you can add and edit fields and metrics displayed in your process app. You can also create new fields that derive their values from an expression or calculation based on values from other fields.

Terminology

• A Field is raw data—individual pieces of information tied to each row in your dataset. For example, a field might represent Price or Quantity for each transaction in a table. Fields describe specific details of each row.
• A Calculated Field is a transformation or computation applied to your raw data at the row level. It combines or modifies existing fields using formulas or expressions, creating new values for each row without aggregating data. For example, Profit might be a calculated field created by subtracting Cost from Revenue for each row.
• A Metric is a summary or an aggregation of data across multiple rows. Metrics combine data using methods like summing, averaging, or counting to create a high-level indicator of performance. For example, Total Profit (sum of all profit) or Average Quantity Sold (average of all quantities) are metrics that help provide insights into trends or overall performance. Once created, metrics can be reused across multiple charts and dashboards. Metrics can be used to calculate other metrics.

To summarize: (Calculated) fields provide detailed information row by row, while metrics summarize and aggregate data across multiple rows to help you see the bigger picture.

Concept	Definition	Example	Data Level	Purpose
Field	Raw data tied to each row in the dataset.	Price, Quantity, Date	Row-level	Describe specific details of each row.
Calculated field	A field created from a computation applied to raw data.	Profit = Revenue - Cost	Row-level	Combine the values of existing fields.
Metric	A summary or aggregation of data across multiple rows.	Total Profit, Average Quantity Sold	Aggregated (multi-row)	Combine data using methods like sum, average, or count.