
Contributor III
2021-07-23
01:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


Master
2021-07-23
07:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
maybe somethink like this
count (contact) / count (distinct Month) average per month
count (contact) / count (distinct Date ) average per day

Contributor III
2021-07-26
01:35 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This doesn't seems correct !
after using this expression
=COUNT(CONTACT_NO)/COUNT(distinct(complete_call.MonthYear))
