Skip to main content

I wanted to calculate all documents processed by any user per day.

Can anyone help with formula or explanation how it can be done

Hi Preethi ,

The Logic Could be:

 

  • Take count of documents processed for a particular period - A
  • Take Count of Distinct related users associated with Documents processed for the same period - B
  • Take the count of Days ( It could be weekdays only or Inclusive of Weekends Too depending upon your actual business Needs) for the same period -C

Formula is: (A/C) This gives you the number of docs processed per day .. Then Divide the same with B to get the number of documents processed by Any user/day

 

No of Documents processed by Any user per day = ((A/C)/(B))

 

Hope this helps..

 

Please mark my response as best - if this is helpful to you.

 

Regards

Ayan

 

 

 


Hi Preethi ,

The Logic Could be:

 

  • Take count of documents processed for a particular period - A
  • Take Count of Distinct related users associated with Documents processed for the same period - B
  • Take the count of Days ( It could be weekdays only or Inclusive of Weekends Too depending upon your actual business Needs) for the same period -C

Formula is: (A/C) This gives you the number of docs processed per day .. Then Divide the same with B to get the number of documents processed by Any user/day

 

No of Documents processed by Any user per day = ((A/C)/(B))

 

Hope this helps..

 

Please mark my response as best - if this is helpful to you.

 

Regards

Ayan

 

 

 

Any example code. If possible?


Reply