I am wanting to see the average daily number of transfers in a hospital by month.
Count(TransferID) will count the total number of transfers for each month. I thought creating a calculation of AVG(Count(TransferID)) and plot that by month would work but that's an invalid calculation.
If I were to do it manually for the month of january
Sum of January Transfers
# of days in January (31)
Average daily count of Visit ID by Month I referred to this thread but I still could not figure it out unfortunately.