Calculating average from Dimension and String Values

[RajatAr]

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

[Harveer_SinghGi1 · Accepted solution]

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!