Value count and date ranges
I am trying to set up a database for a small business and I am trying search how many business introductions each employee gets.
I am able to do this with this calculation
ValueCount( FilterValues( List( business numbers::Employee Name); (Employee::Name)))
However, I need to be able to sort this by date so I can see week,month, quarter, or whatever I want.
Right now the database is simple two tables employee table and business numbers table. The only relationship is business numbers::Employee Name and Employee::Name.
Thanks for any and all help