Condition based field

[cathyw49544988]

We used an eVar1 to track a data and we have another eVar2 to track the similar data with another eVar.  Right now, we would like to create a calculated field which has the logic:

if( eVar2 )  = eVar2

else = eVar1

I noticed that calculated Metrics only can be used for numeric fields. Anyone know how to do this?

Thanks.

[Andrey_Osadchuk · Accepted solution]

It is possible to create an advanced calculated (derived) metric. Use the If function for building that condition.
If the segments are not available for you, this may be because of the license.

See for reference – Calculated and Advanced Calculated (Derived) Metrics