Capacity chart

Hi,

I need to create a capacity chart. •For incidents without a task, use the Due date to allocate the effort into the weekly intervalFor incidents with tasks, use the tasks Due date to allocate the effort. For these incidents, the Incident total effort should be excluded from calculation.

I need to show data according to weekly. So interval is week, but Iam not getting this calculation of effort correctly. My formula is, count(distinct if(NVL(tasks.i_id , 0) > 0, tasks.c$actual_effort, incidents.c$actual_effort)).

is this correct?

Regards,

Meera