4 Replies Latest reply on Jan 17, 2014 8:37 AM by Joshua Milligan

    Average number of records by day of week

    Marc-Paul Lee

      I thought I was pretty knowledgeable about Tableau but I've run into a brick wall on this one and haven't been able to find any solution in my web searching here and elsewhere.  Part of the problem is that it's difficult to describe. 

       

      Let's say I have a month's worth of data where each record is tagged with the date.  I want to know the average number of records for each day of the week.  For example, in a given month there may be four Mondays with record volumes of 20, 32, 45 and 33 for each of the four weeks or 130 total. The average volume on a Monday then is 130/4 or 32.5.  The attached workbook gives a simplified example of the data and the expected solution. 

       

      I imagine I need to use an aggregate function or two but as of yet I haven't been able to get this to work.  Any suggestions? 

       

      Thanks!