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

Dimension Values Comparison

  • March 3, 2025
  • 4 replies
  • 665 views

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

Best answer by 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.

4 replies

eautoaccess
eautoaccess
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.

Josh__Stephens
Community Advisor
Josh__StephensCommunity AdvisorAccepted solution
Community Advisor
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.

Harveer_SinghGi1
Community Advisor
Harveer_SinghGi1Community Advisor
Community Advisor
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!

Sukrity_Wadhwa
Community Manager
Sukrity_WadhwaCommunity Manager
Community Manager
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!

Sukrity Wadhwa
Terms & ConditionsAccessibility statement

Loading footer...