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.