Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm filling a table in my dashboard, and I'd like to count, for each user, the number of customers managed yesterday.
I have my column with all the users, and I'm adding a new column with the count (distinct) of the customers, but I can't do it.
Let yesterday=date(firstworkdate(Today()-1, 1)
I tried many ways but I can't fill my column properly (in the first case I get "-" as result, in the second one I get always 0):
=if(date(DocDta)=yesterday, count(distinct CUSTOMER_ItemDes))
=count({<DocDta={yesterday}>} distinct CUSTOMER_ItemDes)
Thank you very much for your help!
Try like this
=Count({<DocDta = {"$(=yesterday)"}>} DISTINCT CUSTOMER_ItemDes)
or
=Count({<DocDta = {"$(=$(yesterday))"}>} DISTINCT CUSTOMER_ItemDes)
Try like this
=Count({<DocDta = {"$(=yesterday)"}>} DISTINCT CUSTOMER_ItemDes)
or
=Count({<DocDta = {"$(=$(yesterday))"}>} DISTINCT CUSTOMER_ItemDes)
Hello,
The first one works, thank you!!