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]

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!