This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I trying to create a data set which is distinct count of customers over a rolling 12 month period, which increments by a month but don't really know where to start so any help would be greatly appreciated. What my desired output would look something like the table below. Have attached a example input data set
@jboyle one approach to solving this problem might involve summarize tools to perform the customer counts, and the generate rows tool with DateTime functions to create the data points required for your analysis: