S
s_stith
We have a time reporting mandate and I would like to show the
percentage of time reported for each resource for a given period. I
can get a rough estimate by using the calculated measure: Actual
Work / Capacity. However, the Capacity measure is not accurate.
The Capacity should vary based on hire date. On an annual report, a
resource that has been with the company for six months should show
about 1000 hours of capacity, rather than the 2000 that displays in
the Capacity measure for that timeframe.
I see that Capacity can be adjusted by altering Max Units, but doesn’t
seem like a good option to edit Max Units for hundreds of resources.
Any thoughts on how I could produce this report, preferably as a Data
Analysis view would be appreciated.
percentage of time reported for each resource for a given period. I
can get a rough estimate by using the calculated measure: Actual
Work / Capacity. However, the Capacity measure is not accurate.
The Capacity should vary based on hire date. On an annual report, a
resource that has been with the company for six months should show
about 1000 hours of capacity, rather than the 2000 that displays in
the Capacity measure for that timeframe.
I see that Capacity can be adjusted by altering Max Units, but doesn’t
seem like a good option to edit Max Units for hundreds of resources.
Any thoughts on how I could produce this report, preferably as a Data
Analysis view would be appreciated.