Set Analysis to Script expression

[Amine]

Hello every body

I want to determinate the Density of each customer. I achieve it with the Set analysis, but i want it in the Script load as a column called DN

Count(distinct {<CA = {">0"}>}ID_CLIENT) / count(distinct all ID_CLIENT)

Thanks

[sunny_talwar]

Is this over a certain dimension/s (just like you would see it in a table object with the dimension/s) or do you need the overall value (just like you could see if you put the above expression in a KPI object)

[sergioskv]

HI!
You need aggregate this expression on field/fields.
Us it with "Group By".