Average income with filters

[Anonymous]

Dear community,

I have the following two custom variables:

• idvisit
• income

and the following field:

• idaction_name

I would now like to calculate the average income, but only for those idvisit that fullfill a certain idaction_name (e.g. idaction_name = 12345).

I assume that I have to use a nested aggregation here, but dont know how to proceed.

Can anyone help?

Thanks so much in advance!!

Best

Philipp