kbeiderman

Hello, I have been given a project to create pie charts for a co-worker. We are in a K-8 school where she wants to chart her teacher observations and show her staff the data from the observations. So, for instance she wants to see how many 1s, 2s, 3s, 4s, and 5s she is giving for each of her indicators of teacher effectiveness. Therefore, the table we have set up has a record for each teacher and then 24 different indicators. Ideally, we will end up with 24 different pie charts which will show the frequency of which my co-worker assigns each number from the rubric. Now, here's my problem. The pie charts not combining like numbers. For example, one indicator "Engages students in learning" has the following frequencies: score of 5: 0 teachers score of 4: 1 teacher score of 3: 2 teachers score of 2: 2 teachers score of 1: 0 teachers score of 0: 0 teachers I would expect the pie chart to have combined the frequency of scores so a score of 4 would be 20% of the pie, a score of 3 would be 40% and and a score of 2 would be 40%. I would then want it to adjust as more teachers get records. However, this is not what is happening. Instead I have a score of 4= 29%, 3=21%, 3= 21%, 2= 14%. 2=14%. I have done some searching on this forum and others and saw something about sorting, but the problem is that each indicator (field) has its own chart, so I do not think I could keep a sort in tact and not affect the other charts. My co-worker who is using this database has no tech background at all and this needs to be fully automated for her use. I am using Filemaker Pro 12 and am relatively new to this, especially charts. I will take any advice you may have to offer. I am having trouble attaching a copy of my DB to this. I don't know why. Thank you! Kim

Hello, I hope I will be able to explain myself well enough to get your help. I have a simple table [Log Entries] with student names, their unique ID numbers, discipline incident date, discipline type, consequence, date reported, and reported by (teacher's name). I want to match the ID numbers with Grade Levels I have from a different source. I want to either import table from file and match or I can relate them somehow. Here's the problem. Each record could have duplicate IDs but are unique from each other. Therefore, when I try to match for Grade Level, I get no matches. I think it's because the ID is used multiple times, but I don't know how to correct the problem. Using a key field could be the solution. I understand how to create a unique key field (auto-enter serial number), but I don't know how to match that with the other file which uses the ID numbers as identifiers. Thank you in advance, Kim