Forum Discussion

smather's avatar
smather
Icon for Helper III rankHelper III
8 years ago

Data Consolidation - Combine Timesheet Data

 Hi all    Totally new to this and have no idea what I'm doing, so if anyone could help that would be great.    Trying to consolidate data from timesheets -- they have five tasks per day that ran...
Need Help
Show and Tell
smather's avatar
smather
Icon for Helper III rankHelper III
8 years ago

Hi v-juanli-msft

 

Is there any chance you could help me out with the formula / how you go about doing that? Or if you know of some help online, point me in the right direction?

 

Many thanks 

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi smather

    Could you show me some data example and what result you want?

    For axample,

    calculating the total time allocated to each task = 
    CALCULATE(SUM(Sheet1[time]),ALLEXCEPT(Sheet1,Sheet1[tasks]))

     

    Best Regards

    Maggie

    • smather's avatar
      smather
      Icon for Helper III rankHelper III
      8 years ago

      Hi v-juanli-msft

       

      this is the data I've got -- some of the tasks (like install) have a job reference allocated to it, so eventually I'd like to be able to sort on how many hours per task type was spent on a job, but I'm not even over this hurdle yet -- thanks for the hand holding.

       

      This is how the data comes through, I'm not sure why task 2 and task 3 for example have blank things at the top with time associated with them, because it's not like that on the timesheet. 

       

      Whenever I try to put them together, it seems to sort on task 1 and then task 2 on how many times it's shown up on task 1? I don't know what's going on there. I'm not sure why Task 3 to 5 aren't grouping together either. 

       

       

      Many thanks :)