3 Replies Latest reply on Oct 6, 2014 4:56 AM by Dimitris Charalampou

    calculate the frequency of  active records from a date range

    Dimitris Charalampou

      Hi there,


      I have a number of users in my table with the following fields:    

      The Id of the user, the account creation date and the account deletion date.

      In another table i have the id of the customer and the date when he posted a comment.

      I want to calculate the comment frequency, meaning how many users have made comments during the period that they were active, per month. For example if at January 2014 i had 2 users that made comments, and i have 5 users in my database but only 3 of them were active in January of 2014 then the frequency for that month is 66,67% (2/3).


      Any suggestions?


      Thank you.