Formula explanation please!!!

[#1]

Hi folks,

Can anyone kindly explain to me how the below formula works?

Max(Total Aggr(Count( Distinct {<[Case Owner]={*}>}%CaseId), [Case Owner]))

Especially I want to clearly understand this part {<[Case Owner]={*}>}%CaseId)

Thanks in advance!!!

[Anonymous]

Part {<[Case Owner]={*}>}%CaseId) returns %CaseId which has "Case Owner".
So,
(Count( Distinct {<[Case Owner]={*}>}%CaseId) - counts number of cases which have case owner.
Next, aggr(...,"Case Owner") - the count above is grouped by case owner.
And,
max() - returns the max number of cases per case owner.
"total" means ignore dimensions in the chart where this expression is used - can't guess more.

Hope it helps...

[#3]

So, I can assume that <[Case Owner]={*}> means every case owner in the list.

Could this one be used instead??

Max(Total Aggr(Count([%CaseId]), [Case Owner]))

Thanks!!

[rohit214]

hi

{<[Case Owner]={*}>}%CaseId)

it means all  value of Case owner field

thanks

rohit

[Anonymous]

Max(Total Aggr(Count([%CaseId]), [Case Owner]))  is close but not exactly the same.  The * "selects" all values - that is it "excludes" Case Owner that is not assiciated with any case.  But it all depends of the overall data model and the data itself - it may or may not be the same..