Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I got a question about Aggr() Function.
How can I use the function {1} which allow no filter with the aggregation function.
Example :
Count(aggr(if(Country='USA', count( distinct Client)),Client))
How can I add {1} to allow no filter ?
Thank you for the feedback
@BrunPierre : I tried your script but still was not. And then, I tried the function below. Now the result is correct, no filter applied. Thank you 🙏
Count({1}aggr({1}if({1}Country='USA', count({1} distinct Client)),Client))
As below.
Count({1}aggr({1}if(Country='USA', count( distinct Client)),Client))
Not working, Dimension like Month is still working @BrunPierre
Correction!
Count({1}aggr({1}if(Country='USA', count({1} distinct Client)),Client))
@BrunPierre : I tried your script but still was not. And then, I tried the function below. Now the result is correct, no filter applied. Thank you 🙏
Count({1}aggr({1}if({1}Country='USA', count({1} distinct Client)),Client))