How to Group by in Appsheet

[shideqiu]

I have 3 tables as following:
Table Employees with columns Name, Email.
Table Timesheet with columns Name, Project, Time in, Time out, Total hours.
Table Projects with columns Project, Total Hours.
How can I create a view for “total hours for each project by each name”?

[Suvrutt_Gurjar]

Welcome to the AppSheet community.

If I have correctly understood your structure and requirement,

please create a summary view such as a table view on the table Timesheet with following group by columns: Projects followed by Name

In the group aggregate setting please have SUM: Total Hours

An example setting below

Relevant help article

help.appsheet.com

How to Control Grouping

You can display your data in sorted categories.