added last 7 days to average bar chart