Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Working out average frequency of a purchase

Copper Contributor

Good Day, 

 

I am looking for some assistance in working out the average frequency of a purchase of our customers. E.g On average a customer makes a purchase every 19 days. 

I only have the below data for the year:

CustomersTransactionsTransaction/Customer
142036165780111.67169591

This is a high level understanding and not something that should be able to be applied to each individual customer as I know that would require individual transaction rows with time and date stamps. 

2 Replies

@Lifestyle889 

You might use

=365/(transactions/customer)

Thank you!