Dimension Values Comparison | Community
Skip to main content
RajatAr2
Level 2
March 3, 2025
Solved

Dimension Values Comparison

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

Josh__Stephens
Josh__StephensAccepted solution
New Participant
March 4, 2025

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.

View reply

4 replies

Sukrity_Wadhwa
Sukrity_Wadhwa
Employee
April 2, 2025

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!

Translate
Sukrity Wadhwa
Harveer_SinghGi1
Harveer_SinghGi1
New Participant
March 5, 2025

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!

Translate
Josh__Stephens
Josh__StephensAccepted solution
New Participant
March 4, 2025

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.

Translate
eautoaccess
eautoaccess
Level 2
March 4, 2025

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.

Translate
Terms & ConditionsAccessibility statement

Loading footer...