1 Reply Latest reply on Apr 13, 2018 12:10 AM by Tushar More

    Daily Average by Month

    Scott Kolar

      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

      divided by

      # 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.