When you want to get consumption data for the last day/week/month, always create a data range for more than what you want.
Example:
If you want consumption for last month -- Last 3 months of data
If you want consumption for last week -- Last month of data
For yesterday -- Last week