Total Time Spent

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
How can I create a report and chart that would consolidate all Time Spent of a person from each table in an app to get overall total time spent?

Example of data can be seen in the attachment.

Photo of Raymond Marlon

Raymond Marlon

  • 124 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
A report or chart only acts on a single table. To get a consolidated report you would need to have a table of the people nd relationships back to each of the three tables.

For example, if that owner field is field Type User, then this new table would have all your Users and have its Key field set to be the User field.

Then you would make relationships back to each of the three tables where 1 person has many easily records.   Then make various summary fields to summarize hours.

But there is not a way to have all the details in one consolidated report.
Photo of Raymond Marlon

Raymond Marlon

  • 124 Points 100 badge 2x thumb
Can you teach me how to do it?

I would need to have the Total Time Spent per person from all the tables.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
Please contact me off line via the information in my profile and we can book a session to do a few fields together.
Photo of Raymond Marlon

Raymond Marlon

  • 124 Points 100 badge 2x thumb
Do you mean contact you via phone?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
I am saying that we can either carry on this conversation slowly via the forum as my time allows, or you can book a consulting session with me where we do the work together on a GotoMeeting as a "doing and training" session.  My contact information is in my profile.