Number stored as text? - How to convert from a prop/eVar to a metric
We all regret decisions in life; in Adobe Analytics we may regret storing a number in an eVar or prop! This is because unlike custom events, you can't perform numerical calculations (such as summing or averaging) on props or eVars.Obviously, you can make changes to your implementation to capture these values in a custom event going forward. However, what can be done about your historical data? Fortunately, using a combination of Classifications and Calculated Metrics this can be taken care of.
Method
To explain the approach, I'm going to use the example of converting from a three-digit number stored in a prop, to a metric. However, this method can be extended to cope with any number of digits and decimal places as well.
Step1: Create classifications
We are going to use classifications to split our number up into separate classifications, one classification for each individual digit in the number.In this example we are dealing with a three-digit number so we will need three classificati