Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Avg([Transactions per day]) = [Total Transactions] / [Number of days]
Same is true for months and any other timeframe.