Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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
Specialist II
Specialist II

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))