I wondered if you could give me some help on a small app I am trying to create to build a very simple schedule table. I have a list of tasks with a start and finish dates fields. I manage to create all the dates in between those start and finish dates, so I can represent these easily , as can be seen in attached qvw file. The problem is I would need to skip all weekends ( and optionally holiday dates ), so the duration of these tasks should account for only working days. I am not sure how I would need to enter the holiday dates , maybe an INLINE table ...but how ? . Also I would need to see days in between two tasks even if there is no work done on these dates.
Current qvw app chart :
Expected chart ( what I would need ) , based on an excel mockup :
I would appreciate any guidance you could give me here.
I wondered if there would be a simple script modification to that one already in my app, that could provide all the reference dates between my start and finish dates BUT excluding the weekends ( and optionally holidays ).
I could probably join that table to a master calendar to get my expected result ( as in my excel mockup printscreen )
networkdays(date_start, date_finish) as Work_days,