Forum Discussion

rajendra1989's avatar
rajendra1989
Regular Visitor
3 years ago

Total value repeats for every row

Hi, I am looking for expert recommendation on one of the dashboard I am working on. Below is my requirement:

  • I have a dataset that flows from a time tracking tool. (Details include project name, resource name, planned hours, billable hours, actual hours)
  • For internal purposes, we have divided every project in our time tracking tool to two - Billable & Operations project. If Operations Project name is ABC_Implementation, the Billable Project name will be ABC_Implementation_ (Followed by "_").
  • The Billable project has details of Project Name, Resource Name, Planned SOW hours, Billable hours submitted every week... and the Operations project has details of Project Name, Resource Name, Actual hours submitted every week...
  • So, my dashboard should have a view as --> Project Name, Resource Name, Planned Hours, Billable Hours, Actual Hours
  • On the project name, I was able to create a new measure that combines both these values
Project_Code = IF(RIGHT('ibpru projects_dim'[project_name],1) = "_",
(LEFT('ibpru projects_dim'[project_name], len('ibpru projects_dim'[project_name])-1)),
'ibpru projects_dim'[project_name])
  • With this I was able to achieve my dashboard as expected (refer the below image).

  • But, here the column Plan Hours, does not give a split by resource, it repeats the total... I guess the reason here is because of the "Project Code" column which is summarized using the above query.

Appreciate any help!!!

Need Help

4 Replies

  • sergej_og's avatar
    sergej_og
    Icon for Super User rankSuper User
    3 years ago

    I guess you are right with your assumption.
    How does your table with "PLAN Hour" look like?
    There should be also a category for splitting PLAN Hours by Project Code and a valid ralathionship.

    Regards

    • Prateek97's avatar
      Prateek97
      Icon for Resolver III rankResolver III
      3 years ago

      Hi sergej_og ,

       

      I think the Plan Hours is present in the default table only and it should already be split at a resoource level. rajendra1989 please confirm.

       

      Also, you can check if the two project names which are coming in two separate rows have the exact same text value. Maybe there is some space somewhere. You can try exporting to excel and compare there.

    • rajendra1989's avatar
      rajendra1989
      Regular Visitor
      3 years ago

      The data for the plan hours comes from a table which fetches data from our time tracking tool using an API. This table has data of project start date, end date, planned hours, planned cost etc.

  • rajendra1989's avatar
    rajendra1989
    Regular Visitor
    3 years ago

    Hi Prateek97 , you are right. The data for PLAN hours comes from a default table.

     

    Yes, I have confirmed that the text in the different rows are same. The screenshot included in the original message is for a single project with 4 resources working on it. The data for column BILL Hours are extracted from the ABC_Migration (Billable) project and for ACTUAL Hours are extracted from the ABC_Migration_ (Operations) project. Ideally, here for the column Planned hours, I would like to show values that are coming from the Billable project (ABC_Migration), in this case. I thought, maybe a filter or IF condition should work, but could not figure that out.