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
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.
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?
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.