I would like to count activities’ numbers daily in my CRM.
I have a table with all my clients and their activities. In this table, I have a “Last Modified” field.
I would count (in another table) how many clients have received some kind of interaction in their records.
So I should have 2 fields in the counter table:
· Today date (manually or automatically inserted)
· A counter of the record modifications in the considered date
Can someone help me out?
Thanks in advance.
(I hope I’ve been clear enough)