aggr count issue

[ioannagr]

Hello everyone.

I want to count the distinct donation dates where the status of the donation is 0  grouped by each donor.

I wrote this :

=aggr(count(count({<donationcompleted='0'>} distinct donationdate)),[donor_id])

and while the expression is 'OK' i get  ' - ' everywhere.

What am i writing wrong?

Thank you in advance.

[sunny_talwar]

May you need an outer aggregation? Try using Sum

Sum(Aggr(
    Count({<donationcompleted = {'0'}>} DISTINCT donationdate)
, [donor_id]))

[shiveshsingh · Accepted solution]

can you try this?

=aggr(count({<donationcompleted={'0'}>} distinct donationdate),[donor_id])

[ioannagr]

Hello Sunny, 

won't this outer aggregation sum the id's? 

Enlighten me on this please

[sunny_talwar]

Sum the ids? Why would it sum the ids? It will sum the Count of distinct donationdate.... but if you already have found your solution... then all good...