Aggr doesn't work when the expression inside is e()

[mohamed_ahid]

Hi all ,

I'm facing a strange probleme(may be not) .

I'm using an aggr function on a set analysis expression like this way :

aggr( count({<area =e(area)>}  bills) , customer)  (i need to have the number of bills agregated by customer not living in selected area )

this expression is not working , but when delete the exclusion formula it works .

Any idea plz

[kuba_michalik]

I'm not sure, but it seems like you were trying to use this aggr() expression as dimension. If so, just repeat the set analysis for the actual expression, which I guess was

Count(customer)

so it would become

Count({<area =e(area)>}customer)

and it shoud start working.

From the example you've posted, a much bigger problem will be getting that dimension to look like that (up to 10 separate values, up from 10 ranges)...

[mohamed_ahid]

the dimension that you saw in the table it used to produce a liste of  number of transactions range (from 1 to 10) .

the expression will calculate the number of customers for every range .