I am creating a chart based on a date and number of working days. What I would like to do is to show the initial date and all the subsequent days in a chart. Let's see and example: a person started to work on 15/10/2015 and worked for 5 days. If we use lastworkday function, it will return 21/10/2015. So, basically, I would like to see in a chart the days 15,16,19,20,21 which one person in each. The chart will have as Y axis for person and X axis for date.
In addition to the problem, I found what is delaying calculation. This is the original function " count( distinct if(([Start Work Date]<=WORK_DAY and LastWorkDate([Start Work Date], Round(([NofDays]/vNofDays),1))>=WORK_DAY), Person)) "
and if I replace LastWorkDate([Start Work Date], Round(([NofDays]/vNofDays),1)), by another field not editable ( [End Work Date]) the problem still occurs.