Dont know if i was able to explain my problem properly or not
but even after lot of try i am not able to get this done
waiting for your comments
Problem is there is lot of Description, Can you Cut it down to What you need, then you may make it Visible for action.
in pivot sheet
there is column " Moved" within that there are two bifurcations "beyond TAT" and "within TAT"
in those columns data is incorrect
e.g. from picked to invoiced(higlighted in yellow) "Moved beyond TAT" value is 1873 which is not correct
the value under "moved beyond TAT" should be 39 and "moved within TAT" should be 1834
I am a bit confused by your description. Please clarify, which diff do you want to analyse? For example, diff between 'picked' and cancelled then diff between picked and invoiced. If so, the calculation is pretty easy.
COUNTD(IF DATEDIFF('hour', [Sub_Order_Created_At], [To Date]) > 6
Trust this helps.
well..it will be a long description
see a order goes through different status e.g. (verified, picked, invoiced,shipped, delivered etc).. i want to create a condition which help me find out that between which two status order is taking more than 6 hours..i have entry and exit time of order in certain status(from_date and to_date)..if my order remains in only one status i will say it "Not Moved" if it goes from one status and recahed to another status i will say it "moved".. now if it has moved depending upon time difference i want to check whether it moved within 6 hrs or not...if yes i will say it Moved within TAT'' if it moved but took more than 6 hours i will say it "Moved but beyond TAT"
hope i am able to explain it