Additional columns
Dimension column
A String column will be automaticaly defined as dimension column.
You can edit column name (here Role) and define if it is a task dimension or a case dimension.
Task dimension
A task dimension is a dimension for which we take data into account for each event. During ingestion, we select the data depending on one of these methods :
- no aggregation
- first ingested non null value
- last ingested non null value
If "no aggregation" is selected, it will not be possible to view the dimension with an aggregation by case.
Case dimension
A case dimension is a dimension for which we take data into account at case level. During ingestion, we select the data depending on one of these methods :
- first ingested non null value
- last ingested non null value
- distinct ingested non null values
Metric column
A Number type column can be defined as metric column or dimension column. A metric column allow to make calculations in the application.
You can edit column name (here Cost), its unit (here $) and defined if it is a task metric or a case metric.
Task metric
A task metric is a metric for which we take data into account for each event. During ingestion, we aggregate the data depending on one of these methods :
- no aggregation
- first ingested non null value
- last ingested non null value
- sum of the values
- average of the values
- median of the values
- minimal value
- maximal value
If "no aggregation" is selected, it will not be possible to view the dimension with an aggregation by case.
Case metric
A case metric is a metric for which we take data into account at case level. During ingestion, we aggregate the data depending on one of these methods :
- first ingested non null value
- last ingested non null value
- sum of the values
- average of the values
- median of the values
- minimal value
- maximal value