Hi,
I have the following data in my data model:
| Resource Name | Project Type | Project Name | Projected Hours | Projected Dollars | Actual Hours | Actual Dollars |
I have ProjectedHours and ActualHours week-wise in my data model. I have taken the sum(ProjectedHours) and sum(ActualHours) directly in my attached sample data.
I want to show what is the Actuals for each resource (project-wise) against their Projections. I am able to create a chart with sum(Actuals) for each resource. But since the Projections are different for each resource for different projects, what object should I use to visualize this?
I'm open to all ideas!
Thanks,
YASH
