I have been tasked with creating functionality in VB.Net to show rolling average for Carriers by Customer dollars.
I will code to get list of Carriers then iterate through my Customer list. However, I am unsure of the rolling average concept. Would that mean a timespan would have to be defined like weekly between 2 dates? Then get the last week $ total in the date range then the week before then the week before all the while averaging the $ totals together?
I know this sounds vague but any kind of discussion is helpful.