My app has a table where each row has a time stamp. These rows contain data for a user's actions and I want to be able to present the user with a lot of reports where the actions should be broken into times. Like comparing the average of X number of actions on Date 1 to the average of actions on Date 2.
To my novice mind this seems like a good place for making views on the fly. For example, if I want to present data for actions between 9-12 - create a view and manipulate using that.
But I thought to ask the forum what might be best practices?