Averaging on groups where the overall fact count is over the general average

[Ori]

hi everyone,

i'm looking for a way to average the row count but only for groups that have a higher row count than the general average by group.

this is the measure i was trying to use:

avg(aggr(count({<assignment_group = {">avg(aggr(count(distinct sys_id),assignment_group))"}>}distinct sys_id),assignment_group))

pretty sure there is something pretty simple and stupid i'm missing.

thanks in advance.

ori.

[Digvijay_Singh]

May be something like this - 

avg(aggr(count({<assignment_group = {"=$(=avg(aggr(count(distinct sys_id),assignment_group))) > $(=avg(count(distinct sys_id)))"}>}distinct sys_id),assignment_group))

[luizcdepaula]

Hi Ori,

If you are trying to use the average total as your baseline, you  need to add the inital measure first, and then add the comparison with the Total to your average statement. Find it below.

avg(aggr(count({<assignment_group = {"=avg(aggr(count(distinct sys_id),assignment_group))> avg(TOTAL aggr(count(distinct sys_id),assignment_group))"}>}distinct sys_id),assignment_group))

I hope it works,

Luiz