Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.