AnsweredAssumed Answered

Value count and date ranges

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

Title

Value count and date ranges

Post

     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

Outcomes