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,

      -Felix