3 Replies Latest reply on Sep 20, 2016 3:44 PM by stephen.ta.0

    Sum of order value and showing when order value exceeded "X" value

    stephen.ta.0

      Hi I want to calculate the total order value per day Monday-Friday.

       

      I then want to look at how many times out of 250+ business days in that year exceeded "X" value and how many occurred on Monday,  Tuesday, etc.

       

      So as a summary:

       

      Sum order value (regardless of order ID just by day) which I will view by Weekday via typical date functions in tableau.

       

      Combine that with a condition to show me how many times within the year an order exceeded "X" value and show the Count for when it occurred Monday-Friday.

       

      Thanks