Forum Discussion

MichaelSX's avatar
MichaelSX
Frequent Visitor
8 years ago
Solved

total hours to date per project

I'm trying to set up a graph that shows the total amount of time spent on a project each month, including all time up to that point.   I have one table that contains all of our employee's time entr...
  • MichaelSX's avatar
    MichaelSX
    8 years ago

    I figured it out after reading this post. The solution is to use a quick filter for year to date

opticshrew's avatar
opticshrew
Icon for Resolver II rankResolver II
8 years ago

Hi MichaelSX

 

How is your data structured? Is it as follows?

 

Projects > Appointments (time associated with a project)

 

Additionally what is your data source?

 

Thanks,

J

  • MichaelSX's avatar
    MichaelSX
    Frequent Visitor
    8 years ago

    TBH I didn't mean to post this yet. I managed to solve some of my issues on my own. The one remaining problem is making the total hours to date filtered by project. I can't post my workbook because it contains personal data about my company and its employees. I'm reading from an excel file with columns: Project, Duration, Start Time, End Time and Total Time. I've set up a Line Chart with Total Time on the axis and the following measure ToDate:

     

     

    ToDate = CALCULATE(SUM(Toggl[Duration (Hours)]),FILTER(All(Toggl),Toggl[Month]<=MAX(Toggl[Month])))

    Month = Month(Toggl[Start Date])

     

    This results in the total sum of Duration accross all projects. I want it to be filtered by a project chosen by a slicer.

    • MichaelSX's avatar
      MichaelSX
      Frequent Visitor
      8 years ago

      I figured it out after reading this post. The solution is to use a quick filter for year to date