3 Replies Latest reply on Aug 15, 2018 10:07 PM by lei.chen.0

    Find the average value based on the number of weekdays YTD

    Felix Surjadjaja

      Hello, I am trying to create a table of the average value over all weekdays every year so it would look like this:


      Screen Shot 2018-08-16 at 7.49.01 AM.jpg

      How can we achieve this in Tableau? I am unable to get the correct value for "# of Weekday" and "Average" fields.


      The dataset is attached.


      Thank you,