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"


      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.