I've been struggling with the idea of what I am trying to acheive for some time.
I'm producing some resource capacity dashbords based on our data from Clarity PPM
In this system, there are projects with 1 or more tasks.
each task will have one or more resources assigned.
That resource then books time (ACTUALS) to the assignment (task) and also has forward looking ETC's on that project.
Aside from the project/task/assignment each resource has a general availability.
ACTUALS, ETCs and Availability are all time-sliced into the same tables
In my qvw, you can see the script has a loop occuring.
I'm reading in the time-sliced data twice. once with actuals/ETCs against time and once with resource availability.
I need them governed by a single data picker, so I can see on a particular date, how many ETCs a resource has (thats the planned schedule) and what their availability is, so a simple sum will show their spare capacity.
I'm not sure how to construct the query so that I can acheive this.
I need the two time slice areas separate from each other, but linked by date.
Thanks in advance for any assistance you might be able to offer.
