Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I would know please how can i calculate the average day of working to produce some articles,
Our factory is closed just Sundays
I tried two methods but it wasn't correct 🙂
First One : AVG(interval(date of creation - date of sending ,'d')) - this formula take into account Sundays so not accurate
Second one : i used the networkdays function,but this function don't take in account the Saturday,our factory work in this day
I have the idea to create a calendar based on all sending date(working days so :-)),and after exclude all days that not included in this calendar,but i asked this question here,maybe a can found another solution not complicated,
Any suggestion please,
Thank you in advance,
I think you need to create flags in script to mark working day or holidays and use set analysis in measures to filter relevant records.
Hello Digvijay,
Thanks for your reply,good idea,but doesn't work for me :/,
My application is in real-time so i take just orders that has been dispatched this day and until now or they still in machine,
An exemple : Product X
Creation_date : 01/03/2018
Dispatched_date: 15/03/2018
if (weekday(Dispatched_date) = 'Sun',0,1) as Is_Working_day ,
if (weekday(Creation_date ) = 'Sun',0,1) as Is_Working_day_v1
So working date = 1 and Is_Working_day_v1 =1 also,
My formula is :
avg({<Is_Working_day = {1},Is_Working_day_v1 = {1}>}round(Interval(Dispatched_date-Creation_date ),'d'))