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


      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.