Reports (layouts) over time
I need to make many reports (layouts) that present summary data over time.
The database has a timestamp field and for every minute of every day will have about 30 entries.
I need to make reports that summarize (either total, average, etc). Results per day, per week, per month, per year.
Do I need to create a field for each day, week, month, year or is there a way to 'group' by that feature using the timestamp.
I know I already need to create each of those other summary field (total, avg, etc) for the many fields shown already, right?