Jump to content
  • 0

Find average work done




I want to create a report to calculate average work done by an individual in a month. Every individual is working on a unique caseid entered in the caspio database and i am recording caseid, individual name/email and timestamp. An individual can work on the same case id multiple days in a month, so i need to do sum total of all case-id's worked by an individual and divide it by number of days the individual worked in a month. Just cant get around to get the results using calculations here. How do i get distinct dates individual worked in totals and aggregation section in report datapage,?


Appreciate your time and help!

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hi @Magnum,

You can use calculated fields with SQL query to count id`s and to retrieve an oldest and the latest date user submitted case id. Finally, you can use DateDiff() function to calculate a number of days the user has been working on the case. You can check the following article for further information about SQL usage in Caspio:


You can check the following topic if you prefer to exclude weekends, holidays from a number of days which individual has spent during working on the case:

Hope this helps.



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...