I am trying to pull together a table of averages across different hours of the day. However, I am having a problem with getting the denominator to calculate properly. In the attached example, I would want the denominator for each of these boxes to be 30 because that is how many days of business we had during the selected time period.
The current formula to get the values shown in the attached image is as follows:
Count(distinct([Appt Date]))
Unfortunately, this is only counting if there is an appointment date for the given time in the table.
