5 Replies Latest reply on Sep 12, 2019 6:28 AM by Zhouyi Zhang

    Date diff using aggregation in the same view

    Sandeep Varma

      Hi Geeks,

      I want to compare the Total Orders vs Orders placed in the last 2 months.

      When I use the DateDiff(below) condition it filters the last 2 months for the end of each month, but wanted to compare in the same view.

      DATEDIFF('month', [Ship Date], [Order Date])

      Please find the work book and data