Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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!!
hi
{<[Case Owner]={*}>}%CaseId)
it means all value of Case owner field
thanks
rohit
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..