Tricky one, Denver. Since only data persisted within the Workfront database can be charted, and since Hours themselves do not support custom data, I have an idea (untested) that might either Just Work, or lead to a solution:
Create a calculated text Custom Parameter called "Reporting Source"
Add the Reporting Source parameter to all Project and Issue custom form(s) of interest (i.e. those under which time is entered)
Set the Reporting Source's formula on the Project form(s) to "Name" (i.e. the Project's name itself)
Set the Reporting Source's formula on the Issue form(s) to "IF(ISBLANK(Resolve Project ID),Project.Name,Resolve Project.Name)" (i.e. the Resolving Project's name, if present; otherwise the Issue's initial Project's name...albeit perhaps temporary until the Issue is converted to a Project, effectively "switching" the time to the latter at that point)
TIP: it might be more efficient to create a one-parm-only Parameter strictly for this purpose, and add it globally to all Templates, Projects, and Issues (and Tasks -- same concept, slightly different formula: "Project.Name", i.e. the Task's Project's Name)
Create an Hour report that Groups by the Project's Reporting Source, then by the Task's Reporting Source (if used), then by the Issue's Reporting Source
My logic is that -- imagining all three being "Project A" across each object -- that the SUM of the Hours (which you'd set on the View) would then roll up the right sub totals at each level
Since each Reporting Source is technically on a different object type, the Chart might consider them as different series, so it might take some finagling (e.g. group by Project Reporting Source, stack by Issue Reporting Source) to get the desired visual
If the latter's not possible out of the box, I'd then punt, and invite you to consider our "http://store.atappstore.com/product/magic-reports/">Magic Reports solution, which I'm sure we could tailor to exactly what you need
Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand!
https://community.workfront.com/participate/unanswered-threads
