4 Replies Latest reply on Sep 12, 2016 3:58 PM by stephen.ta.0

    Sum per Weekday and Max value

    stephen.ta.0

      Hi I am looking at order data through Monday-Friday.  I am using built in tableau functions to change my "date" to weekday.

       

      I want to know the MAX value of orders based on one years worth for each day Monday-Friday.  My issue is when I am trying to do this it is only able to pull the MAX value of a specific order on that day not the whole SUM of orders.

       

      How do I combine SUM/MAX to work properly for this?