Forum Discussion

GarnseyG's avatar
GarnseyG
Helper I
6 years ago

Measure from two tables

I have one table containing the names of different tasks and a field called Window that define a number of days. Table is call Tasks and has three elements, Task, Job, Window.   A second table iden...
Need Help
GarnseyG's avatar
GarnseyG
Helper I
6 years ago

Ashish,

 

Thanks. It's a great start I think. It doesn't report task g as 0% and when I look at it by project rather than task it doesn't calculate correctly. However, I'm hoping this gives me enough of an idea to do what I need. I'll let you know.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • GarnseyG's avatar
    GarnseyG
    Helper I
    6 years ago

    This works for the individual tasks, but not for projects. Three of the four have the same percentages for each task (projects P1, P2, and P4) so the project level numbers are correct I think only because of this. But project P3 is wrong. There are 8 people who have reported time (yes some are the same person in different tasks but that doesn't matter) and 4 have time within the window. Project p3's percent should be 50%.

     

    In total, 20 people (again the fact it was the same person in different tasks is not important) reported time and in 13 cases they were in the window, so 65%.

     

    Hopefully this better explains it all. I do very much appreciate your working on this!!!