Calculating process time in FTE's

[Anonymous]

Hello

I am trying to build a dashboard that will show how many FTE's my organization has used on a given process 

I have data like this:

ID      Process              Start date               End date            Process time (Calculated column)

1        Process A          1/1/2018 12:44      1/1/2018 13:42   00:58

2        Process B          2/1/2018 08:14      2/1/2018 08:44   00:30

3        Process A          3/1/2018 15:08      3/1/2018 16:00   00:52

Based on this I can easily calculate how many hours we spend on each process, but I would like to know how many FTE's we spend on each process. For this example I define one FTE as 2080 hours/year equivalent to 40 hours/week. 

The question is: How do I make a visualization where the FTE is calculated correcly, even if the time period is changing. If I choose a week in the visualization, it should divide the number of hours used with 40, and if a choose a year it should divide with 2080?

Any suggestions?

[v-frfei-msft]

Hi @Anonymous ,

Did you mean changing the value by a slicer? Then we can create a measure using IF function to work on it.

---

The question is: How do I make a visualization where the FTE is calculated correcly, even if the time period is changing. If I choose a week in the visualization, it should divide the number of hours used with 40, and if a choose a year it should divide with 2080?

---

[Anonymous]

Correct, that is one thing i would like it to do. The other thing is, that if I have a bar chart with the date on the x axis, then if i drill down to e.g. weeks then I would like it to show 1 FTE if 40 hours were spent on the process, and if I drill up to show it per year, then it should show 1 FTE if 2080 hours were spent on the process.

[anneshibuya]

Hi,

I have the same challenge. Did you find a solution?