Forum Discussion
Calculating process time in FTE's
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?
3 Replies
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?
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.
Hi,
I have the same challenge. Did you find a solution?
