I have a CSV file that has all the hours ive worked and for which client.
I want to be able to see I worked for XYZ and total have worked 20 hours.
for ABC company I worked 40 hours total... How can I achieve this?
I have a CSV file that has all the hours ive worked and for which client.
I want to be able to see I worked for XYZ and total have worked 20 hours.
for ABC company I worked 40 hours total... How can I achieve this?
Import into FileMaker, and change the hoursWorked
field to a number. Create a summary field called something like summaryTotalHoursWorked
set to the Total of the hoursWorked
field.
Then create a subsummary report:
company
summaryTotalHoursWorked
in that partcompany
and then look at the total displayed in each subsummary part.You can also use a similar approach to create a chart showing this info if you prefer that to a grouped list.
Thank you @jwilling that helped a ton!
Now would I need separate tables or could this all be done in one table.
This can all be in one table! E.g.:
company | hoursWorked | summaryTotalHoursWorked |
---|---|---|
Acme | 10 | 20 |
Acme | 15 | 25 |
Zoro | 8 | 14 |
Zoro | 4 | 14 |
Zoro | 2 | 14 |
You simply create a list, sort by company, and put summaryTotalHoursWorked
in a subsummary part (when sorted by company).
summaryTotalHoursWorked
does not have to be in each list row, only the subsummary part.
Thank you I have done that!
My next question how could I create a chart showing a grouped list
Sure, simply:
company
as the sort order if you sorted in step 1company
field. Set the Y-Axis to your hoursWorked
field (no need to use the summary field in the chart, it'll do the summarizing for you.)Then save and it should show you a bar chart with total hours for each company.
I have a few columns in different tables with ID's missing.
Is there an easy way to copy and paste Client_PK to another table/layout?
I don't fully understand exactly what you're going for, but there are many ways to move data between fields/tables. E.g. Replace Field Contents
, a script using Set Field
in a loop, or good ol' Import Records
.
hahah thank you
I hope that last answer didn't sound dismissive or anything like that, I meant it sincerely, given my limited understanding.
No you’re good ! I understood
Sort of kinda asked, but knew the answer. Sort of.
Like “there must be a better way to do this ?!” Lol