String to numeric count in CJA

Forum|Forum|10 months ago
April 1, 2025
3 replies
661 views

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

Analytics

Best answer by Deepika_S_V

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.

D

Deepika_S_VAccepted solution

Level 2

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.

Josh Stephens

Community Advisor

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!

M

mmartee

Hi @rajatar,

do you have a lot of dimension values within that dimension? If not, maybe you can try CASE WHEN function to convert it. That worked for me for a specific use case.

Josh Stephens

Community Advisor

Actually Adobe just released the typecast derived field function this week that makes it easy! It's great to see the product evolving in ways that solve painpoints.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded