2 Replies Latest reply on Mar 1, 2017 7:40 AM by aftab.najib

Creating a Calculated Field based on count

Hi, I am looking to find out how I can write a calculated field in order to workout targets for each teacher. So for example if I have Teacher A who has 20 students then the teachers target will be 20 for the month but then I need to divide this Weekly.

I have the fields Week_Ending (set as Friday), Class and tests that the teacher has done.

An example of my data:

Teacher A has done 5 tests WE10.02.17, 1 test WE17.02.17 and 1 test WE24.02.17. The teacher or class has 20 students so the target is 20 tests per month and divide by the number of weeks in Feb which is 4 so target would be 5 per week.

This would then allow me to build a doughnut chart that will show for each week how many tests were done against the target.

So this will show me 5 tests were completed for WE10.02.17 and met the target (shown in a doughnut chart).

Hoping somebody can help.

• 1. Re: Creating a Calculated Field based on count

Hello Aftab,

Your  number of weeks will be 4.  So your calculation will look like  COUNTD(Students)/4 and then pull Week field to find the target of all respective weeks.

Hope this helps

1 of 1 people found this helpful
• 2. Re: Creating a Calculated Field based on count

Shripal, thanks for your response, I'd like the number of weeks to be dynamic as this will vary month to month.