AnsweredAssumed Answered

Value count and date ranges

Question asked by TerryWonycott on Aug 5, 2013
Latest reply on Aug 6, 2013 by philmodjunk


Value count and date ranges


     Hey everyone,


     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