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.

Thanks

• ###### 1. Re: Sum of order value and showing when order value exceeded "X" value

Take a look on this one.

• ###### 2. Re: Sum of order value and showing when order value exceeded "X" value

Hi Luciano,

Unfortunately I cant open the version as I am waiting for my key to be updated for Tableau 10.

Could you explain what you did?

Thanks,

• ###### 3. Re: Sum of order value and showing when order value exceeded "X" value

Hi Luciano, I took a look at and why is there a THEN "order id" after?  I could not get it work for what i was trying to do