HELLO , i have ORDERS , each can have maximum 4 steps , step have from and to dates , and a close step can be only a step with one step a head ( if i have steps 1 2 3 then 1 2 are close and 3 is open ) , if there are 4 steps then all are close :
i have a pivot table that shows for each city (hebrew) the avg (months) time for each step :
avg step 1
= sum ( aggr ( avg ( Interval( if ( is_step_Close = 1 and step = 1 , to_step_date - from_step_date ) ,'d') / 30 ) , city ,step ) )
i need to sum all steps avg BUT only for the orders with all 4 steps , how can i do that ?
- Sorry I did not mention the following detail : all expresions ment only to CLOSE STEPS.