I want to create a drill down on my bar chart. The first layer will be the date which is no problem as the raw data is already grouped by date. I have to identify the specific project so my expression reads:
The next layer I want to drill down to will be by resource. The problem is, the data is coming through with each resource showing as their own field.
The script is showing:
'ProjectXYZ' as Project
Resource 1 and Resource 2 have the hours they are allocated to that specific project for that specific week. I want to take both of these fields and group them into a 'Resource' field. That way my second level on the drill down will be this field - So when I click on a specific date, it breaks that date out by resource.
Not at all, just add those back into the loads. I am not sure if you need to add the rvariables into the concatenated load or not, so assuming you do, I just added them in as '0' records as not to duplicate the sums of resource 1 or resource 2. You'll need to check how that is handling Total and Needed in your actual script as well.