Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
can you try this?
=aggr(count({<donationcompleted={'0'}>} distinct donationdate),[donor_id])
May you need an outer aggregation? Try using Sum
Sum(Aggr(
Count({<donationcompleted = {'0'}>} DISTINCT donationdate)
, [donor_id]))
can you try this?
=aggr(count({<donationcompleted={'0'}>} distinct donationdate),[donor_id])
Hello Sunny,
won't this outer aggregation sum the id's?
Enlighten me on this please
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...