{<FIELD=>} not working in AGGR() function

[#1]

Hello,

I am using count of FIELD1 across dimension FIELD and using AGGR() to do group by of FIELD2,FIELD3,FIELD4 in a chart. Also i have used {<FIELD=>} as the set modifier so that the selection in FIELD should not reflect in chart. The chart is working unless i don't make a selection in FIELD. As soon as selection is done in FIELD, the chart changes according to the selection thus ignoring the set modifier {<FIELD=>}.

Can someone explain the reason of this different behaviour.

Expression - count({<FIELD=>} AGGR(FIELD1,FIELD2,FIELD3,FIELD4))

Also AGGR(count({<FIELD=>} FIELD1),FIELD2,FIELD3,FIELD4) is not fetching any result, so i used the above expression.

[jagan]

Hi,

I think instead of using Aggr() and getting count, try like this

LOAD

*,

AutoNumber(FIELD1 & FIELD2 & FIELD3 & FIELD4) AS Key

FROM DataSource;

Count({<FIELD=>} Distinct Key)

Note: Aggr() will have performance issues.