Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
6 years ago

Summing like fields

I'm trying to come up with a creative solution to an issue. Two tables, projects and time cards. Time cards is child. I have many time cards (hundreds) for dozens of employees (lets say 40).  Each ...
Relationships
DonLarson's avatar
DonLarson
Qrew Elite
6 years ago
Mike,

What is the business use for summing the Time Card Data?   Is the summation about the project or about the Employee?


If you are trying to monitor or learn about the Employees you only need a single summary field in the Employee Table.

If you are trying to slice and dice employees  vs projects for trends in time card generation, you really need to use a different tool for that sort of multidimensional analysis.  Something like Tableau or Power BI will let you write SQL queries to give you a large array of values that are not dedicated fields in Quick Base.


------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
  • MichaelTamoush's avatar
    MichaelTamoush
    Qrew Captain
    6 years ago
    Don,

    In this particular case the business use is to generate a pay app to an entity (a prime contractor in this case). Our invoice includes a line item that shows how many total hours a particular employee worked on a certain project. Right now, my data import gives me the total hours per time card, per project. I do not have access to change the data I get, so I need to combine all the time cards on a certain project, for a certain employee, into a single total hours for that employee so that I can utilize that number on an exact form plus document.

    ------------------------------
    Mike Tamoush
    ------------------------------