Jon Coon

I'm trying to understand avg ticket per hour for each day as well.

@... can you provide any clarity or link to an explanation on why the daily avg seems to default to 1 no matter the numbers. Is there a way to change that when there are low frequencies to get a decimal less than 1?

For example:

- Total tickets will be between 1 and 6 (7 days in the week) for a specific time period in a given day

- Daily avg metric your referenced will always say 1 when clearly it is less than 1 (let's say there were 2 tickets total in hour 22 so the actual avg should be 2/7 = .28 tickets per day)

I've tried to manipulate this in different ways but think I am missing something.