Hi Team I am using CJA, and I have a metric which is in string format i.e., web1 &45,343 &52,671 &53,234 so on..
because of which my I am not able to see my total number i.e. aggregated value at the top is there any solution for it to get the aggregated value by converting it into int from DataView itself
In Adobe CJA, if a metric is stored as a string , it won’t be added up. To fix this, change the Data Type to Integer in Data Views so the values calculate correctly.
If special characters are causing issues, use Data Prep to clean the values before storing them.
In Adobe CJA, if a metric is stored as a string , it won’t be added up. To fix this, change the Data Type to Integer in Data Views so the values calculate correctly.
If special characters are causing issues, use Data Prep to clean the values before storing them.
If the data type is a string, you can't do math with it in CJA. You can cast as an integer using data prep, but that's only for new data after you add that mapping.
Alternatively, you can use Report Builder to get the numeric "string" into Excel. There you can use it as a number. Hope this helps!
