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