Forum Discussion
Calculating process time in FTE's
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?
