topic Re: set analysis - combining ignore selections and another condition in App Development

set analysis - combining ignore selections and another condition

Ori — Thu, 16 Jun 2022 12:27:56 GMT

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!!!

Re: set analysis - combining ignore selections and another condition

marcus_sommer — Thu, 16 Jun 2022 13:36:44 GMT

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

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

- Marcus

Re: set analysis - combining ignore selections and another condition

Ori — Thu, 16 Jun 2022 13:43:50 GMT

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

thank you again!