6 Replies Latest reply on Sep 27, 2016 3:50 PM by Santiago Sanchez

    Sum of Orders and a Count of Order Values by day that exceeded "X"

    stephen.ta.0

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

       

      Out of the 250+ business days in a given year I want to see how many times a a days order exceeded "X" value and then see whether that occurred on Monday or Tuesday and so on.

       

      In 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