Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mahnoor1279
Contributor III
Contributor III

How to calculate average no of calls per month

I have data of calls having contact numbers and  details of duration of calls  and i want to know about the average calls per day and per month w.r.t contact no

 

 

2 Replies
brunobertels
Master
Master

maybe somethink like this 

 

count (contact) / count (distinct Month) average per month 

count (contact) / count (distinct Date ) average per day 

mahnoor1279
Contributor III
Contributor III
Author

This doesn't seems correct !

after using this expression 

=COUNT(CONTACT_NO)/COUNT(distinct(complete_call.MonthYear))