Behavior settings are available on both dimensions and metrics. The available settings depend on the component type and schema data type.
|Lower case||De-duplicates rows that have the same value but different case. If enabled, all instances of a dimension with the same value are reported as lower case. For example, your data contains the values
If you enable Lower case on a lookup dataset dimension, multiple lookup values can exist for the same identifier. If this conflict happens, CJA uses the first ASCII collated value (Uppercase values precede lowercase values). Adobe advises against using lookup datasets that contain the same value when Lower case is enabled.
|Count values||Visible on Integer and Double schema data types. Increase the metric by the specified amount. For example, increases a metric by 50 if the value of the column is
|Count instances||Visible on Integer and Double schema data types. Increase the metric by one, regardless of the value. The presence of any value increases the metric. For example, increases a metric by 1 if the value of the column is
|Values to count||Visible on Boolean schema data types. Lets you determine if the metric increases by counting
You can generate both an ‘Orders’ and ‘Revenue’ metric in Analysis Workspace using the same event dataset column with different behaviors. Drag the ‘Revenue’ dataset column into the data view twice and set one to ‘Count values’ and the other to ‘Count instances’. The ‘Orders’ metric counts instances, while the ‘Revenue’ metric counts values.