Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
DGAL1
Contributor III
Contributor III

Average per month and average per day

I have sales for the entire year, and I want to calculate the count of transactions done on average per month and those done on average per day. Am using the column called ID to identify each transaction uniquely and a column for dat

Labels (2)
1 Reply
LRuCelver
Partner - Contributor III
Partner - Contributor III

Avg([Transactions per day]) = [Total Transactions] / [Number of days]

Same is true for months and any other timeframe.