Calculating average from Dimension and String Values | Community
Skip to main content
R
RajatAr
Level 2
April 17, 2025
Solved

Calculating average from Dimension and String Values

  • April 17, 2025
  • 1 reply
  • 348 views

Hi Team

I am using CJA

I have created some filters i.e. 

filter1                                          Events
  event action
       Select 1                                 
       Select 2
       Select 3
       Select 4
       ..Till Select 7
filter2 
    event action
      Same as filter 1
.
/
till filter4

Is there any possible way, I can get the average of all the filters
i.e. filter 1 (Select 1) + filter 2 (Select 3) + filter 4 (Select 5) | filter 3 (Not Selected anything)

Then based on User_id, I can average it 
(1 + 3 + 5)/3 = 3


Best answer by Harveer_SinghGi1

Hi @rajatar ,

It would help if you can add more details. From what you have shared it is not very clear what you are trying to achieve but it looks like you are trying to create certain filters with defined event actions and then for each filter you want to see how many of those event action based conditions were met and then take average based on the returned numbers, is this correct? Can you share few more details with an example of what values you expect and what results you'd like to return.

Cheers!

1 reply

Harveer_SinghGi1
Community Advisor
Harveer_SinghGi1Community AdvisorAccepted solution
Community Advisor
June 24, 2025

Hi @rajatar ,

It would help if you can add more details. From what you have shared it is not very clear what you are trying to achieve but it looks like you are trying to create certain filters with defined event actions and then for each filter you want to see how many of those event action based conditions were met and then take average based on the returned numbers, is this correct? Can you share few more details with an example of what values you expect and what results you'd like to return.

Cheers!

    Terms & ConditionsAccessibility statement

    Loading footer...