Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Suggestion on finding totals and averages against non additive measures

  1. #1
    Join Date
    Jul 2008
    Posts
    3

    Default Suggestion on finding totals and averages against non additive measures

    Hello List ,


    We have data in somewhat below form:

    project name resource time taken(Calendar) Man hours
    P1 R1 100 100
    P1 R2 100 100
    P2 R3 175 175
    P2 R4 175 175
    P3 R5 150 150


    ** Date hierarchy is also present

    Out of this data i need to generate two kinds of reports:

    1. Total Man hours used in each project which is quite straight forward and I can get it by summing "man hours" column for each project.

    2. Place where I need help is calculating calendar duration for each project from calendar point of view. Any suggestions here will be really helpful:
    We need results like this:
    Calendar Duration for Projects:

    P1 = 100
    P2 = 175
    P3 = 150


    Regards,
    Ashish

  2. #2
    Join Date
    Jan 2013
    Posts
    796

    Default

    Can you say a little more about what the "time taken" measure is and how it is different from "man hours"? Is it elapsed vs. actual?

    It might help also if you could give an example of desired results that show both man hours and time taken side by side and how they should differ.



    Quote Originally Posted by toashishk View Post
    Hello List ,


    We have data in somewhat below form:

    project name resource time taken(Calendar) Man hours
    P1 R1 100 100
    P1 R2 100 100
    P2 R3 175 175
    P2 R4 175 175
    P3 R5 150 150

    ** Date hierarchy is also present

    Out of this data i need to generate two kinds of reports:

    1. Total Man hours used in each project which is quite straight forward and I can get it by summing "man hours" column for each project.

    2. Place where I need help is calculating calendar duration for each project from calendar point of view. Any suggestions here will be really helpful:
    We need results like this:
    Calendar Duration for Projects:

    P1 = 100
    P2 = 175
    P3 = 150


    Regards,
    Ashish

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.