This project is becoming more complex since the user should be greeted with a flexible graph of their data.
User should be able to choose the date range and the interval displayed should adjust intelligently. This means that sums need to be calculated (add up all hourly intervals for a day sum, add up days for weeks, months, etc.) The question is whether this should be calculated in advance and if so what is the appropriate key to store it under in the database? The current database is keyed by a start time that is hourly - should there be other databases keyed by daily, weekly, and monthly intervals?
Analytics need to be implemented quickly (before Alpha) so that the user is presented with useful information that can impact a reasonable change in habits with measurable outcome.
This project is becoming more complex since the user should be greeted with a flexible graph of their data.
User should be able to choose the date range and the interval displayed should adjust intelligently. This means that sums need to be calculated (add up all hourly intervals for a day sum, add up days for weeks, months, etc.) The question is whether this should be calculated in advance and if so what is the appropriate key to store it under in the database? The current database is keyed by a start time that is hourly - should there be other databases keyed by daily, weekly, and monthly intervals?