AnsweredAssumed Answered

How to count records for every week/month

Question asked by muhammad.ikram@contedia.com on Jan 6, 2017
Latest reply on Jan 7, 2017 by philmodjunk

Greetings,

 

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.

Outcomes