2 Replies Latest reply on Nov 11, 2016 10:18 AM by David Hernandez

    Daily Average

    David Hernandez

      I am trying to calculate the daily average over a month. For example, I have a total count of events for a month and want to divide that number by the total calendar days for that month and place it in a column. In the image shown I did a straight out division by 31 but I want to do it for the actual number of days for that month. I tried doing a window_ave but that give me the average/month over the 3 months (Col 1). Column 3 shows the total number of events for that month. In this case I'd like to setup the calculation so for may and July the total is divided by 31 and June by 30 days. Sorry, Tableau noob here

      table_01.PNG