Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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))