added location to user and fixed big where time totals truncated days