I have a quick requirement to analyze counts of a measure dynamically 5,4,3,2,1 weeks prior to a date field, count on that day and count 2 weeks after that date.
I have attached a workbook with the superstore DB. I would like to get counts of order id for past 5 weeks based on the ship date, count of orders on that particular ship date and count of orders 2 weeks later that ship date. For reference I have attached an excel image the report look something like that. Please let me know if you need any information.
I'm going to have a colleague take a look at this question and hopefully we can get you a helpful answer :-)