Dimension Values Comparison

[RajatAr2]

Hi Everyone
I am using CJA 
I have a Dimension in it, the dimension name is type
in the type there is
Engagement numbers - i.e. (10, 20, 50, 100, 120, 150, 200 etc) 
click numbers
and others
I wanted to create a filter i.e. the Engagement numbers are > 250 

But it's a dimension, is there any way I can use these numbers for comparison in CJA

[eautoaccess]

Since "type" is a dimension, it's treated as a string, not a number, so you can't directly filter with `> 250`. You'd need to create a classification or use a calculated metric to convert those values into a usable numeric format for comparison. Another option is to apply segmentation by manually grouping the engagement numbers that are above 250.

[Josh__Stephens · Accepted solution]

In CJA, dimensions can be numbers/integers.  However, if the data type is string, then you can't do what you're wanting to do in Workspace.  You can use Report Builder to get the numeric strings into Excel where you can treat them as numbers.

[Harveer_SinghGi1]

Hi @RajatAr2 ,

Can you try duplicating this dimension and then converting the duplicate component to metric using component type setting, that metric then should be available for using in comparisons you want.

Cheers!

[Sukrity_Wadhwa]

Hi @RajatAr2,

Were you able to resolve this query with the help of the provided solutions, or do you still need further assistance? Please let us know. If any of the answers were helpful in moving you closer to a resolution, even partially, we encourage you to mark the one that helped the most as the 'Correct Reply.'
Thank you!