Newbie question about sum of records

[langille]

Hi all, this is my first time posting here, and Id like to say hi to everyone as this seems like a really friendly group, and im thankful this site exists.

First the background...Ive been using filemaker for a bit and have used it to run simple sports stats without problem (wins, losses, points. etc..)

Now I have been asked to create a database for work that tracks staff stats (I work in a callcenter) I have built a database that tracks all the stats individually for each week, which all pools into a layout for the quarter, everything works fine if you want to see what a certain tech support agent has done for the week, month or quarter.. but where Im lost is how I would be able to tell how an entire team did.

I have each tech agent entered by name, id number, team, and group. What I would to do is be able to add up the stats for a team and average it, but I have no idea how to do that.

IE: Search for Team A, it will list the 10 techs that are on Team A, and then sum their stats into one record and average it.

Is this even possible? Ive looked over the site tonight, but haven't seen anything that looked like this.

Thank you for all your help, and sorry for such a long winded first post, but I figured a lot of info and background was better than "how do I do this?"

Thanks again

Langille

[mr_vodka]

Hi and welcome to the forums.

What is your tables structure like?

You can handle this in a few different ways. You could use a subsummary report or possibly using the sum () function.

So tell us how it is set up so we can help you better.

[langille]

Thanks for the quick reply

How i have it set up is that i have 13 tables, each repesenting a week of the year. ie: Dec 31, Jan 7, Jan 14, etc...

In these tables, I have a number of fields, some for input, (name, pin, calls taken, etc...) and some for calculation (% taken, % of short calls, etc)

I also have 3 tables for a "monthly overview" and each of these have their respective weeks pool into them.

This works great when I want to look at Tech ABC because i have relationships between the tables, but what if i wanted to look for all the team members of Team XYZ, and average those numbers? That way I can say ok, Tech ABC, here are your stats, and here is the average versus the rest of the team?

Thanks again mr_vodka

Edited January 22, 2007 by Guest

[mr_vodka]

13 tables? I think you may be going about this the wrong way. You should have a record for each week per year; not a table for each one.

[langille]

thanks for the reply.

maybe i am going about it wrong, but here's my set up

1 table for each week, in that table has the variables im collecting, like calls answered, lates, sicks, etc... each is a different field. I have X amount of records in each table, depending on how many techs were logged in that week.

I did this for the first 3 weeks of this year.

Am i going about it wrong? like is there an easier way?

Thanks again.

Brian

[mr_vodka]

I mean maybe you should try something like this.

call_stats.zip

Edited January 23, 2007 by Guest
Error capture added

[langille]

Mr Vodka, this is nothing short of amazing. I will look at this and study it tonight, thank you SO much, I will follow up tomorrow, but even before I look at this, i really want to thank you for your help.

Thank you

[langille]

Hi Mr_Vodka, I would have Private Messaged this but I didnt see an option for that. I wanted to say thank you again for all your help with the demo you sent me. Unfortunately I never had time to try it as just after that, my mother became very ill and I have been out of the province. This is my first time back to the boards, and didnt want you to think that i wasnt appreciative of what you've done, and I will be taking time to look and study what you gave me. Thank you.

Brian

[Lee Smith]

If you click on the name of the person in the Profile to the left, it will give you a menu where you can send a Private Topic. Third choice.

Anyway, this was perfectly okay to post in the Thread. You can't get enough kudos.

Lee