AnsweredAssumed Answered

How to count records for every week/month

Question asked by on Jan 6, 2017
Latest reply on Jan 7, 2017 by philmodjunk



I need some assistance  with creating a Chart on my filmmaker application. I have an time-recording table in my database.


I would like to have an chart showing the number of activities per week added per week, or per month, or per year.


I believe i need a way of counting record in a week or month or a year. What is the best approach to have some sort of structure of splitting the data in different time periods; than displaying them on chart.


Many Thanks in Advance.