1 Reply Latest reply on Nov 11, 2015 12:10 AM by diego.medrano

    Prior and Future weeks

    Sagar S

      Hi Everyone,

      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.