set analysis - combining ignore selections and another condition

[Ori]

hi everyone.

been wracking my brain around this question for a couple of hours.

I'm trying to aggregate an average across a dimension, ignoring selections made to one dimension (caller_id) and filtering another based on a condition. 

it worked perfectly before I added the second condition but now selection made to caller_id changes the result.

the formula is as follows :

avg({$<caller_id=>} TOTAL <prob_cut_060_fusion_subject_>

aggr(count({$<caller_id=, subject_caller = {"=count(distinct sys_id) > 1"}>} distinct sys_id),subject_caller)

/

aggr(count({$<caller_id=, subject_caller = {"=count(distinct sys_id) > 1"}>} distinct opened_at_ym),subject_caller)


)

I'm sure there is an expert here that can help me resolve this issue.

thanks!!!

[marcus_sommer · Accepted solution]

You need to apply this condition everywhere - means also here:

...
subject_caller = {"=count({$<caller_id= >} distinct sys_id) > 1"}
...

- Marcus

[Ori]

thank you so much!!! it seems obvious now that i'm thinking about it!!!

thank you again!